topic Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone in DAX Commands and Tips

add a column that puts PM whenever power bi finds that the date is the previous month just gone

Anonymous — Thu, 21 Nov 2024 11:27:33 GMT

I am trying to add a column that put PM whenever power bi finds that the date is the previous month just gone.

Is PM =

IF (

'Append'[Previous Month] = PREVIOUSMONTH(FinDate[Date]),

"PM",

"NO"

)

I get no syntax errors, but when i run it I get this error:

The name 'IF' wasn't recognized. Make sure it's spelled correctly

Please can you help?

Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone

shafiz_p — Thu, 21 Nov 2024 11:31:14 GMT

Hi Anonymous Try below code to create a calculated column:

Is PM = IF ( MONTH('Append'[Date]) = MONTH(TODAY()) - 1 && YEAR('Append'[Date]) = YEAR(TODAY()), "PM", "NO" )

Output:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone

saurabhtd — Thu, 21 Nov 2024 11:33:29 GMT

Anonymous You are unable to find 'Append'[Previous Month] beacuse Append and FinDate are two different tables which might not have relationship between them.

Alternatively if you wan create a column to decide Is PM you can try below code it calculates based on 'FinDate'[Date]

IsPM = IF ( 'FinDate'[Date] >= EOMONTH(TODAY(), -2) + 1 && 'FinDate'[Date] <= EOMONTH(TODAY(), -1), "PM", "NO" )

Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone

Anonymous — Thu, 21 Nov 2024 11:50:50 GMT

For some reason this didn't work. I get this error:

A single value for column 'Date' in table 'FinDate' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Can you help?

Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone

Anonymous — Thu, 21 Nov 2024 11:53:48 GMT

Thank you. When I try to use your suggested code, I can't find the column (it doesn't show). Only measures are suggested.

Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone

shafiz_p — Thu, 21 Nov 2024 12:05:18 GMT

That was a example. You need to use your date column.

Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone

Anonymous — Thu, 21 Nov 2024 12:06:28 GMT

Sorry, I was creating a measure rather than a column. When I went to create a column it worked. THank you

Re: add a column that puts PM whenever power bi finds that the date is the previous month just gone

FreemanZ — Thu, 21 Nov 2024 12:15:02 GMT

hi Anonymous ,

you can also try like:

Is PM =

IF (

EOMONTH('Append'[Date], 0) = EOMONTH(TODAY(), -1),

"PM",

"NO"

)