Thank you for sharing the knowledge but hear is some scenario if i want to select a date like 10 nov or any date of month but when I am using the same dax it's giving me all sales of privious year. And in mtd scenario also
Step 1 - find the 4 year old value using calculate and datediff Step 2 - find the current value Step 3- use divide function or relevant growth call to get the growth %
Clean n clear👌
Thank you sooooooo much for this great information ❤🎉
Thank you for sharing the knowledge but hear is some scenario if i want to select a date like 10 nov or any date of month but when I am using the same dax it's giving me all sales of privious year.
And in mtd scenario also
Is it possible to remove the 2017 year using a filter? will this impact all the other calculations?
Thank you.
Hi sir then what is the dax function to find growth over a four year period
Step 1 - find the 4 year old value using calculate and datediff
Step 2 - find the current value
Step 3- use divide function or relevant growth call to get the growth %
Sir if i have only the year column but not the date column,how the measure calculate is done