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 ...
  • amrosullivan's avatar
    4 years ago

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