Forum Discussion
Parallelperiod ,dateadd is not working
Hello,
I have been trying to get the previous month sales based on the year selection . But Dax seems to be correct but i am not getting any values except blanks . I tried with Parallelperiod , Dateadd ,sameperiodlast Still getting the blank instead of sum of sales . Could you please let me know where am i going wrong here ? w
Prev.Yr Month Sales = CALCULATE(SUM(Orders[Sales]),SAMEPERIODLASTYEAR(Orders[Order Date]))
Anonymous , You need to use date table joined to date of your table and then try meausre like. moth in viusal should come from date table
Prev.Yr Month Sales = CALCULATE(SUM(Orders[Sales]),SAMEPERIODLASTYEAR(Date[Date]))
refer other reason
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
2 Replies
Anonymous , You need to use date table joined to date of your table and then try meausre like. moth in viusal should come from date table
Prev.Yr Month Sales = CALCULATE(SUM(Orders[Sales]),SAMEPERIODLASTYEAR(Date[Date]))
refer other reason
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.Right-click on your Date table --> Click on Mark as Date table --> Select the Date column --> Validate --> ok.
this should solve your problem.
