Flagging date that meets a certain date criteria

[Anonymous]

Hi, I have been playing a bit around but struggling to write a dax query that will flag transaction for the first 4 days of each month.  

Original Data
GL Date	Amount
1/05/2023	100
3/05/2023	200
24/05/2023	300
1/05/2023	400
Output
GL Date	Amout	After month end
1/05/2023	100	Yes
3/05/2023	200	Yes
24/05/2023	300	No
1/05/2023	400	Yes

[eliasayyy · Accepted solution]

Hello please follow

Flag = 
VAR _day = DAY('Table'[GL Date])
RETURN
IF(
    _day <=4,"Yes","No")

[FreemanZ]

if you need a measure, try to plot the columns with a measure like:

Measure = 
IF(
    DAY(MAX(data[Date]))>4,
    "No", "Yes"
)

it worked like:

[FreemanZ · Accepted solution]

hi @Anonymous 

try to add a calculated column like:

Column = 
IF(
    DAY([Date])>4,
    "No", "Yes"
)

it worked like:

[eliasayyy · Accepted solution]

Hello please follow

Flag = 
VAR _day = DAY('Table'[GL Date])
RETURN
IF(
    _day <=4,"Yes","No")