Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add last month closed flag in DAX or Power Query

Hi everyone !   I need to show the data up to the last closed month in my report. Example: today is 10/15 (October is an open month) in this case I need to view all the data for the year up to 09/...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can add this column to your Date table and then filter on "Y" to see only closed months.

     

    Closed Month = if(EOMONTH('Date'[Date],0) <= TODAY(), "Y", "N")
     
    Regards,
    Pat
     
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can add this column to your Date table and then filter on "Y" to see only closed months.

 

Closed Month = if(EOMONTH('Date'[Date],0) <= TODAY(), "Y", "N")
 
Regards,
Pat
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks mahoneypat  !