Solved: Error Dax Month Function

Anonymous · ‎10-22-2021

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 · ‎10-27-2021

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

Anonymous · ‎10-27-2021

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 · ‎10-22-2021

Wrap the red underlined column with MAX()

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Anonymous · ‎10-22-2021

It should be a measure.

Thanks

Anonymous · ‎10-22-2021

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

Error Dax Month Function