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
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

  • 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.