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