Forum Discussion

EmilijaN's avatar
EmilijaN
Icon for Helper I rankHelper I
3 years ago
Solved

Column(Y/N) last 12 weeks

Hello , 

 

I am trying to create a column which is going to calculate is the date in last 12 weeks or not.

 

I am using this formula:

Last_12_weeks = if('CALENDAR'[Week Rank]>=max('CALENDAR'[Week Rank])-12 && 'CALENDAR'[Week Rank]<=max('CALENDAR'[Week Rank]),"Y","N")
but if I put this formula in the calendar table it is taking only the last 12 weeks from the calendar table. I need to use Today(), but I do not know how to usi it. 
 
Any suggestions?
 
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi EmilijaN ,

     

    Please try:

    Last_12_weeks =
IF (
    DATEDIFF ( 'CALENDAR'[Date], TODAY (), WEEK ) >= 0
        && DATEDIFF ( 'CALENDAR'[Date], TODAY (), WEEK ) <= 12,
    "Y",
    "N"
)

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

2 Replies