Parallelperiod ,dateadd is not working

[Anonymous]

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]))

[Manish09]

Right-click on your Date table --> Click on Mark as Date table --> Select the Date column --> Validate --> ok.
this should solve your problem.

[amitchandak · Accepted solution]

@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.