Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Changing the date when comparing values

Hi, I'm doing some calculations where I calculate the values +1 day and +8 days against the selected date. But when I'm selecting a date in first table the date doesn't change in the other tables. I...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    You need measures as below:

    For +1 day:

     

    +1day = SELECTEDVALUE('Table'[Date])+1
    +1 value = SELECTEDVALUE('Table'[Value])+1

     

    For +8 days:

     

    +8 day = SELECTEDVALUE('Table'[Date])+8
    +8 value = SELECTEDVALUE('Table'[Value])+8

     

    Finally ,you will see:

     

     

    For the related .pbix file,pls click here.

     

    Best Regards,
    Kelly

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I created the calendar table and joined it with my table. The comparing is going good but my dates are still staying the same. 

amitchandak's avatar
amitchandak
Super User
6 years ago

Please provide a sample what you want to show vs what you are getting

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I updated the post with a foto of the expected result I'm trying to get.

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Not sure I still got it.

      But if we want to show date of 7th and show diff 6th and 7th we use -1 day measure

      but If want show same on 6th we will use +1 day measure