Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
NickDSL
Helper I
Helper I

Filter to start showing data on a certain day of the month

Hi I have the following Calendar table:

NickDSL_3-1695848855361.png

 


My goal here is to have a 1 or 0 filter in a DAX column to show when the "start of month" is for reporting purposes (numbers don't become official until a certain day of the month).

For example:

Today is 9/27/2023 it should return a 0 TODAY. All dates in current month should return a 0 until the 7th of the following month is hit. So in this case when the date hits 10/7/2023 all dates in September should flip to a 1 while keeping 10/1-10/7 a 0. This should loop for all future months. All previous dates should return a 1. In this case 8/1/2023-8/31/2023 should return a 1 TODAY and when the next month hits. 

2 REPLIES 2
nirali_arora
Resolver II
Resolver II

You can try the following measure

ReportingWindowFlag =

VAR CurrentDate = TODAY()

VAR StartOfMonth = DATE(YEAR(CurrentDate), MONTH(CurrentDate), 1)

VAR EndOfReportingWindow = EDATE(StartOfMonth, 1) + 7

RETURN

IF(StartOfMonth <= CurrentDate && CurrentDate <= EndOfReportingWindow, 1, 0)

Hi @nirali_arora. This solution does not work. It returns a 1 for all date values even today which should be a 0. I am looking to make a "Helper Column" not a measure. This solution does not work when implemented as either.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.