Forum Discussion
Time Period -1 year
Hi emiliadgw ,
For the fields in the slicer, please use the date column from the calendar table.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
emiliadgw You can below functions:
SAMEPERIODLASTYEAR - https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
DATEADD - https://docs.microsoft.com/en-us/dax/dateadd-function-dax
Could You please help me with the formula? When i'm using SAMEPERIODLASTYEAR sum is only for one year, not for whole date range.
Hi emiliadgw ,
Create a calendar table, then use the date column to create a relationship between the fact tables, and then create two measures.
Please try:
the selected time period = SUM('START PROMO'[SUM])the same period year ago = CALCULATE([the selected time period],SAMEPERIODLASTYEAR('Calendar'[Date]))The PBIX file is attached for reference.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data