Check End of the Month and return Value

[gssarathkumar]

I have a below table, I need to add a condition column to check the end date of a month and return a value as below:

Kindly help me to get the same.

@amitchandak @Greg_Deckler @lbendlin @DesktopOwl @Goodlytics4U @HelpMe @Ahmedx @v-huijie-msft 

[gssarathkumar]

I need to do this in the Power Query, I will have to find out the month end and then use the respective Binary content.

@nandic @lbendlin @PijushRoy 

[PijushRoy · Accepted solution]

Hi  

Please look into my previous comment, both Power Query & DAX solutions mentioned

if [Date] = Date.EndOfMonth([Date]) then "True" else "False"

[lbendlin]

[Date] = Date.EndOfMonth([Date])

[PijushRoy]

Hi @gssarathkumar 

In DAX calculated column

Column = If(
    'Table'[Date] = EOMONTH('Table'[Date],0), "True","False")

If you need in Power Query, please find the custom conditional column syntax

if [Date] = Date.EndOfMonth([Date]) then "True" else "False"

[lbendlin]

Since you seem to want to return a boolean you could simply write

Column = [Date]=EOMONTH([Date],0)

[PijushRoy]

Hi @gssarathkumar 

Please find the DAX calculated column formula

Column = If(
    'Table'[Date] = EOMONTH('Table'[Date],0), "True","False")

[nandic]

Formula for required column would be:

Required Formula = IF('Table'[Date]=ENDOFMONTH('Table'[Date]),TRUE(),FALSE())

Cheers,
Nemanja Andic