Forum Discussion

vivaldii's avatar
vivaldii
New Member
2 years ago
Solved

How can I compare dates selected from two separate slicers?

Hi, And I need change percentage also number of changes    
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi vivaldii ,

     

    You need a separate dates table that doesn't have relationship to your fact You can create one in DAX by referencing the original Dates table

    Dates2 = Original_Date.

     

    Please see sample pbix for reference.

samratpbi's avatar
samratpbi
Icon for Super User rankSuper User
2 years ago

You may create 2 different instances of date table and join with your main / fact table. And then put slicer based from those 2 different date tables and also create 2 set of count measures based on 2 date tables.

If this resolves your problem, then please mark it as Solution, thanks!

vivaldii's avatar
vivaldii
New Member
2 years ago

Hi, it didn't work.