Forum Discussion

jyaul786's avatar
jyaul786
Helper II
2 years ago
Solved

Last three day

i have fact table with data by date, fact table is related with calendar table. and i need to get sum of last three day value based on date slicer(from calendar table). Fact Table: Date value ...
Need Help
jyaul786's avatar
jyaul786
Helper II
2 years ago

i cant create unrelated table, i have many table related with calendar table using as Dates slicer from calendar table. do you have any other way then please help me ? thanks

    • jyaul786's avatar
      jyaul786
      Helper II
      2 years ago

      Hello,

      Thanks for your help, its working fine. Could you please do one more favour for another measure: when i select date range1 like:

      the result_min = 6+7+8

       

      and date range1 like:

      result_min=3+4+5

       

      How can i achieve this ? please help me.

      Thanks

       

       

      • Ahmedx's avatar
        Ahmedx
        Super User
        2 years ago

        happened

        pls try this