Forum Discussion

jyaul786's avatar
jyaul786
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper 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
    Icon for Helper II rankHelper 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
      Icon for Super User rankSuper User
      2 years ago

      happened

      pls try this

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      2 years ago

      Now it won’t work without an unrelated table since the date range does not fit into the slicer range