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

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

    • NewbieJono's avatar
      NewbieJono
      Post Partisan
      5 years ago

      sorry to bother you agian, i have reviewd the file. its so close to what i need. but i have set up two identical filter on my page. one to select comparison 1 and one to select comparison 2. the date filters are based on the same data table. is there any method for this ?