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

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

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

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