Error Dax Month Function

[Anonymous]

Hi,
Does anyone know hot to change the name underlined in red in order to not get the error in the picture below, please?
Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

[Lasttwelvemonth] needs to be a measure(return single value)or a certain value.

If it's a column, you will need to wrap it with MAX(), MIN() or SELECTEDVALUE() function according to your need.

If it's already a measure, please share the formula with us for further check.

Best Regards,

Jay

[PaulDBrown]

Wrap the red underlined column with MAX()

[Anonymous]

It should be a measure.

Thanks

[Anonymous]

HI @Anonymous 

 Is the Lasttwelvemonth a measure or column?

 You need to make sure the datatype of the [lasttwelvemonths] is set to date.

Thanks
Raj