topic Re: Flagging date that meets a certain date criteria in DAX Commands and Tips

Flagging date that meets a certain date criteria

Anonymous — Wed, 10 May 2023 06:48:31 GMT

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.

eliasayyy — Wed, 10 May 2023 07:06:36 GMT

Hello please follow

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

FreemanZ — Wed, 10 May 2023 07:12:13 GMT

hi Anonymous

try to add a calculated column like:

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

it worked like:

FreemanZ — Wed, 10 May 2023 07:15:14 GMT

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: