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 ...
Need Help
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

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, NewbieJono 

I am not sure if my sample pbix file suits to your case.

Please check the link down below, that is the sample pbix file.

 

All measures are in the file.

 

https://www.dropbox.com/s/htc1thl34ruoueh/newbiejono.pbix?dl=0 

 

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

    thank you, this is almost there. howver i only have 1 date table, and 1 data table. is there a method like this ?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi, NewbieJono 

       

      Please check the link down below.

      I tried to meet your requirement, but still not sure if it is what you are looking for.

       

      I cannot know all the business cases in the world, but I have not seen a case like what I have just created. So, I am not convinced about it, but I tried to meet your requirement.

      Please kindly check.

       

      https://www.dropbox.com/s/7a475ned6fugt02/newbiejono%202.pbix?dl=0 

       

      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

        Thank you for your time on this. i have a table that shows a snapshot of date selected. my user want to compare snapshots.

         

        normally i would just do a trend graph. but the snapshot also includes an"oldest date" field. this field displays the oldest date of work currently on record.

         

        e.g today the oldest date shows 23.02.    the oldest date yesterdy was 21.02