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]
    )

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

Thanks for your Blog link amitchandak 

But can you help me with this, Ihave to deliver it to the client,
Right now I have a slicer of Seasonal Week on my Weekly Report, and I have to create another Weekly report which will show only the Last Week Data based on filter of the calculated column which I had created. 
True = last Week,
False = This Week,
False = rest of the weeks, how should I apply it to that report?