Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Error Dax Month Function

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    Anonymous
    Not applicable
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    It should be a measure.

    Thanks