Fantastic tutorial ..loved it ..was so confusing until I watched ur video ..now it is clear 👍you have simplified it ..very nice initiative on time intelligence functions
Thanks for sharing and I have something similar like this. I thought I could use the PARALLELPERIOD but then my calendar table has a column named "Payperiod". It is a payroll calendar and the period one date started in December 2020. Pay period is every two weeks. The pay period was determined on the dates. How do I do a pay period over pay period percentage change? Do you have any similar videos? Thanks a bunch!
bzflowerbee, Thanks for your question. The concept should be the same. Just make sure that you are using a calendar table to perform this type of analysis. Also, you might want to use DATEADD and the interval should be DAY, and the number of intervals, -14. Example: DATEADD (Dates[date], -14, DAY)
Sravan, Thanks for stopping by. One way to create dynamic measures could be by using What-If Parameters. This tutorial might help. ua-cam.com/video/v7GqLXfq3O4/v-deo.html
Hi Nestor I have one query, i am working on power bi project , somebody has already created one table formatted one is coverage to budget and coverage to forecast, forecast , under this they had written some measure this section completely filled with grey colour. my task is remove this grey colour and formatted as it is when i remove the this colour the structure completely changed, l i was working on last 2 days onward, completely i fed up this work, can you please explain the tricks , if any body created table or matrix , how should we check what format's are used and how to use as it is. can you help me please. give me email id if i get any doubts i will reach out you.
It seems that it's a formatting situation. Have you tried changing the style of the table/matrix? e.g., Select the table > Format (Below Visualizations) > Style
@@NestorAdrianzen Already somebody has developed the table. Just i remove the background color and do same formatting. They used different grids in top and bottom, how should we know what they have taken the all format given to the values
Hi Nestor i have one doubt , we get a data from cube , it means they wrote a Dax queries in analysis services . here my work is check the data validation part. i don't know how to check. compare reports in power bi and cube data in excel. i have to create one validation sheet in excel check the validation part. how to do in excel and how to check the values is equal or not. when we refresh the excel the values are automatically changes, and also copy these values validation part paste special under i have one difference sheet data if it is equal zero if get any other number it is error. can you make a one video, please bro it is my sincere request, nobody can help me , please save my life and job
The method in the video shows comparing the data of a month with only previous month. How can I compare a data of a month with same month of the previous year?
Hi Sir...This Zuheb..I have Send you So many Comment on your wonder full work,.SIr...I have one challenge in preparing a DAX for my management ask below is the requirement I'm looking for, Please help me in this or make a video on the same it will great help. I have a column in my dataset name as product Working Capital - Secured Business Development- Secured Asset Purchase- Secured Working Capital - Secured Asset Purchase- Secured Working Capital - Secured Business Development- Unsecured Working Capital - Secured Working Capital - Secured Working Capital -Unsecured Asset Purchase- Secured I need substring as Secured and Unsecured in different column Please help me in this Sir. Thanks in Advance Zuheb HS
@@NestorAdrianzen Thank you Sir...for your replay it means a lot...I did the same way what you have explained in the video 25:13 ua-cam.com/video/ZaqyUK-PtzE/v-deo.html.
And Sir I have some more data on which you can prepare the youtube videos....if you will to do...Please email me on this email id hszuheb@gmail.com. Thanks & Regards Zuheb H.S
![5 DAX Tips that You Should Know [Power BI 2021]](http://i.ytimg.com/vi/e8u60NkVNDo/mqdefault.jpg)
![5 DAX Tips that You Should Know [Power BI 2021]](/img/tr.png)
![How to Compare Time Periods in Power BI [By using DATEADD]](http://i.ytimg.com/vi/32wDjtPBxQY/mqdefault.jpg)
Thank you! This is the 7th video I've wanted on ParallelPeriod and you are the first to show what the data model looks like.
Glad it was helpful! Cheers!
so clear and simple explanation, perfect
Thanks for your feedback, Michal!👍
Excellent tutorial Nestor. Thanks for explaining the differences between these 3 DAX functions.
Glad you found it helpful, Iván. Keep up the good work!
Fantastic tutorial ..loved it ..was so confusing until I watched ur video ..now it is clear 👍you have simplified it ..very nice initiative on time intelligence functions
Glad it was helpful! Keep up the good work, K s!
Hi Adrianzen, very useful tutorial, just one question, if the Premium YOY growth should be Premium Month on Month Growth? Thanks a lot
Yeah. You are correct. The name of the measure should have been Premium MoM. Thanks for catching that up. Cheers!
Fantastic example
Glad you found the content helpful. Cheers!
Muy interesante tutorial, me veré todos y sobre todo que son en inglés así también de paso practico mi listening :)
Excelente!👍
Excellent video bro
Thanks for the visit. Keep it up, Prabha!👍
Thanks for sharing and I have something similar like this. I thought I could use the PARALLELPERIOD but then my calendar table has a column named "Payperiod". It is a payroll calendar and the period one date started in December 2020. Pay period is every two weeks. The pay period was determined on the dates. How do I do a pay period over pay period percentage change? Do you have any similar videos? Thanks a bunch!
bzflowerbee, Thanks for your question. The concept should be the same. Just make sure that you are using a calendar table to perform this type of analysis. Also, you might want to use DATEADD and the interval should be DAY, and the number of intervals, -14.
Example: DATEADD (Dates[date], -14, DAY)
@@NestorAdrianzen What if the periods are not the same? I am trying to compare sales on a fiscal calendar (5-4-4) where the period crosses 2 months.
Nice explanation Nestor. these are the Normal KPI, how to create dynamic kPI's in power bi
Sravan, Thanks for stopping by. One way to create dynamic measures could be by using What-If Parameters. This tutorial might help. ua-cam.com/video/v7GqLXfq3O4/v-deo.html
@@NestorAdrianzen Thanks Nestor
Hi Nestor I have one query, i am working on power bi project , somebody has already created one table formatted one is coverage to budget and coverage to forecast, forecast , under this they had written some measure this section completely filled with grey colour. my task is remove this grey colour and formatted as it is when i remove the this colour the structure completely changed, l i was working on last 2 days onward, completely i fed up this work, can you please explain the tricks , if any body created table or matrix , how should we check what format's are used and how to use as it is. can you help me please. give me email id if i get any doubts i will reach out you.
It seems that it's a formatting situation. Have you tried changing the style of the table/matrix? e.g., Select the table > Format (Below Visualizations) > Style
@@NestorAdrianzen Already somebody has developed the table. Just i remove the background color and do same formatting. They used different grids in top and bottom, how should we know what they have taken the all format given to the values
Hi Nestor i have one doubt , we get a data from cube , it means they wrote a Dax queries in analysis services . here my work is check the data validation part. i don't know how to check. compare reports in power bi and cube data in excel. i have to create one validation sheet in excel check the validation part. how to do in excel and how to check the values is equal or not. when we refresh the excel the values are automatically changes, and also copy these values validation part paste special under i have one difference sheet data if it is equal zero if get any other number it is error. can you make a one video, please bro it is my sincere request, nobody can help me , please save my life and job
Sravan, I need to do more research on this. Thanks for your suggestion.
The method in the video shows comparing the data of a month with only previous month. How can I compare a data of a month with same month of the previous year?
Thanks for stopping by. It should be very similar. You should use YEAR instead of MONTH withing the DATEADD function. I hope that helps. Cheers!
Hi Sir...This Zuheb..I have Send you So many Comment on your wonder full work,.SIr...I have one challenge in preparing a DAX for my management ask below is the requirement I'm looking for, Please help me in this or make a video on the same it will great help.
I have a column in my dataset
name as product
Working Capital - Secured
Business Development- Secured
Asset Purchase- Secured
Working Capital - Secured
Asset Purchase- Secured
Working Capital - Secured
Business Development- Unsecured
Working Capital - Secured
Working Capital - Secured
Working Capital -Unsecured
Asset Purchase- Secured
I need substring as Secured and Unsecured in different column
Please help me in this Sir.
Thanks in Advance
Zuheb HS
You might want to use Power Query: Add a column from example. This tutorial will help. Min 25:13 ua-cam.com/video/ZaqyUK-PtzE/v-deo.html
@@NestorAdrianzen Thank you Sir...for your replay it means a lot...I did the same way what you have explained in the video 25:13 ua-cam.com/video/ZaqyUK-PtzE/v-deo.html.
And Sir I have some more data on which you can prepare the youtube videos....if you will to do...Please email me on this email id hszuheb@gmail.com.
Thanks & Regards
Zuheb H.S
PARAMETERS VS FILTERS GIVE 5 POINTS