Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
5 years ago

compare values between two dates

Hello, i have a page with 1 table and date select, i also have another table and date select. both tables are identical but the date select allows you to load two tables with diffrent date snapshots for comparison.

 

is there a way i can compare the total in one table to the total in another.

 

e.g

 

Fitler Date 1 -  1 /1/2021 - Volume 1000

 

Fitler Date 2 -  1/6/2021 - Volume 2000 ( 100% increase)

 

Thanks all

 

Need Help

9 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, NewbieJono 

    Please correct me if I wrongly understood your question.

    One of ways to show two results in one table is to have two measures that calculate different times.

     

    If it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with a solution.

     

    Thank you.

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    • NewbieJono's avatar
      NewbieJono
      Post Partisan
      5 years ago

      sorry i am unable to share my file, but your idea sounds like it could work. could you give me an example of the DAX

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi, NewbieJono 

    If you have two slicers created from the same date table( maybe you have edit Interactions of slicer visual),you can't use min and max to get the values of these two slicers separately like Jihwan_Kim  did in the second attached file.

     

    You must add another date calendar table and apply them to the slicers separately, as shown in Jihwan_Kim  first attached pbix file.

     

    Best Regards,
    Community Support Team _ Eason