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 amitchandak ,
Working Great!!

It shows Winter Week 16 as Last Week, and Winter Week 17 as This Week.

I need little help over here

But, I want to apply this column as a filter to a weekly report and send that weekly report on every monday and they can see the last week filtered report due to this column.

Because, Power BI Email Subscription don't send the report in the last week selected slicer, it always send the report in the slicer which were selected before to counter this problem I used this last week logic and use that column as a filter which will always be filtered with the last week data.

but I dont' see any data when I applied it as a filter any ideas?