Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic year on year calculation

Hi all,   I am trying to figure out how to calculate a dynamic year on year calculation. I am using the following calculation options: Total Sales SamePeriodLastYear = CALCULATE ( [Total Sale...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , In this case, use date month and year from the fact table, instead of date table.

 

Also, if one table is independent and another on is joined, you should be able to use date table

How to use two Date/Period slicers:https://www.youtube.com/watch?v=WSeZr_-MiTg

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

    Thanks for your reply. I am sorry but I forgot to mention that, in my fact table, I only use a DateKey which has many to one connection with the Date table.

     

    Is it then also possible to use the solutions displayed in the YouTube video?