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...
Still a little lost, I created a simple model, can you give an example of the calculation process using the model?
Best Regards, Gao Community Support Team
If there is any posthelps, then please considerAccept it as the solutionto help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know.Thanks a lot!