Forum Discussion

HKInd's avatar
HKInd
Icon for Helper I rankHelper I
3 years ago

Need Help with Last 3 Weeks Total Calculation in Report Slicer

Hi All,

Please help..!

 

Need help with calculating "last3WeeksTotal" based on the selected Weekending date in the slicer. The formula I provided is showing blank results:

 

I have applied below DAX but it showing blank result :- 

3Wkstotal =
CALCULATE(
    SUM('Date_set'[Revenue]),
    FILTER('Date_set',
    'Date_set'[Order Stage] = "Ordered"
    &&'Date_set'[Scope] = "Order"
    ),FILTER('CalendarDate','CalendarDate'[Date]>=[Selected_date]-27 && 'CalendarDate'[Date]<=[Selected_date]-7))

 

Report link below:

https://www.dropbox.com/s/6jvwyryae34ormg/3Weeks%20Total%20issue.pbix?dl=0 

Any suggestions or corrections are welcome!

Need Help

3 Replies

    • HKInd's avatar
      HKInd
      Icon for Helper I rankHelper I
      3 years ago

      aj1973  Thanks for your reply, But It should work on slicer basis, If i selected date in slicer it should change date calculation accordigly. You have removed selectedvalue feature in solution.

    • HKIndia's avatar
      HKIndia
      Icon for Helper I rankHelper I
      3 years ago

      Please see below screenshot of what help i need, I have two columns Dates and Sale and at the bottom i have written start date of the week and end date of the week and total is 1675 from 3July to 23July when 30July Weekending date is selected.