Forum Discussion

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

Table "true/false" last 3 month

Hi,

 

I work on a table who tells me YES or NO if is the current month, previous month etc...
No problem for current month and previous month. But I try to create a new column for the "last 3 month" (actually : January 2023. So last 3 month = December/Nov/Oct 2022).
But when I write : MONTH(TODAY())-3  on DAX, I only have the last month (December...) and I don't know why.

Is it possible ? What i'm doing wrong ?

 

Thanks for help !! 🙂

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    chestercas ,  Try logic based on Eomonth

    example column

    if([Date]>= eomonth(Today(),-3)+1 && [Date]<= eomonth(Today(),0) , "Yes", "No")

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    chestercas ,  Try logic based on Eomonth

    example column

    if([Date]>= eomonth(Today(),-3)+1 && [Date]<= eomonth(Today(),0) , "Yes", "No")

    • chestercas's avatar
      chestercas
      Icon for Helper I rankHelper I
      3 years ago

      Thank you so much ! I've tried the OEMONTH logic, but not like this.
      I need the last 3 month, not included the current month, so I correct like that :

      if([Date]>= eomonth(Today(),-4)+1 && [Date]<= eomonth(Today(),-1) , "YES", "NO"))
       
      Thanks again for your help !!