Need Help on Dax date measure

[coolshib]

Hello People,

I have two columns in my dataset, one is [Date] and another is [Filing date].

I am looking for a dax formula which would return value based on following condition:

  If [Filing date] < 11th day of Next month considering [Date] column then True else False.

For Example, if my date column is 18th April 2022 & my filing date coloumn is on or before 11th May 2022 then the result would be True  and If filing date column is on or after 12th May then the result would be false.

Hope i have explained my query properly.

Thank you so much in advance.

Best Regards,

Shib 

[amitchandak · Accepted solution]

@coolshib ,

A new column

if([filling Date] < Eomonth([Date],0) +11, True(), False())

[coolshib]

Thank you so much.