Forum Discussion

HKInd's avatar
HKInd
Helper I
3 years ago
Solved

WeekEnding date slicer

I have below data set:- Table Name:- Order data Country City Date Order Rate Total Cost Country1 City1 7/1/2023 18 216 3888 Country2 City2 7/2/2023 27 191 5157 Country3 ...
Need Help
  • HKInd's avatar
    HKInd
    3 years ago

    Nithinr Thanks for your quick help on this:-

    I have to apply one more condition like : order >50
    Monday_cost =
    CALCULATE(SUM('Order data'[Total Cost]),FILTER('Order data','Order data'[Weekday]=2),FILTER('Order data','Order data'[Order]<50))
     
    It is providing correct answer but any other better way
HKIndia's avatar
HKIndia
Helper I
3 years ago

Nithinr  Thanks for your reply!

 

Can we add an entry for Current week and should be set as default. so that when user open the report, should get current week selected.