Forum Discussion

MH3's avatar
MH3
Icon for Helper V rankHelper V
5 years ago
Solved

Showing Last Week as true in a Calculated Column

Hello,  I have a calender table in DAX, which   Starts from: May   Ends On:   April I have Fiscal Weeks which is  May's First week from Monday to Sunday is being counted as 1 FiscalWeek. and...
Need Help
Show and Tell
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    MH3 , Based on what I got you can have columns like these. Merge using var if needed

     

    Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1 //Monday Start
    Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

     

    Week Type = Switch( True(),
    [start week]<=Today() && [end date]>=Today(),"This Week" ,
    [start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
    [Week Name]
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

MH3 , Take a slicer of the page-level filter and set it to true?

MH3's avatar
MH3
Icon for Helper V rankHelper V
5 years ago

amitchandak 
I have used that Column and applied the Basic filtering of True, with Seasonal Weeks, the silcer picking up data correct but it's not selecting that Week in the slicer and hence the data is not being filtered

ScreenShot