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

v-kelly-msft's avatar
v-kelly-msft
Community Support
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

    The first formula is exactly what I need. But I can't put that measure as my rows in my matrix table. There is a work around for putting a measure in, so i'm going to try that.