Forum Discussion

amrosullivan's avatar
amrosullivan
Frequent Visitor
4 years ago
Solved

return selected date less n value for available dates

hello, i am at my witts end!

 

i have a calendar table - i am using the dates as a slicer

i have a fact table with columns - reporting date (these are not continious dates), Attribute 1 and value 1

 

i want to be able to select a date from the slicer (calendar dim date) and return value 1 from the previous row of the fact table. and then create another measure to return the value 1 from the selected date less 2 rows from teh fact table and so on update 5 rows.

 

this essentially means i want to dynamically return the previous value, the selected value - 1 row, the selected value - 2 row, the selected value - 3 row and so on... 

 

please could someone help with how to do this?

 

thank you!!

  • the calculation worked by creating an index column on the facr table and then creating measures for max value, selected index - n

2 Replies