Forum Discussion

agustira97's avatar
agustira97
Frequent Visitor
3 years ago

query referenced calculated column doesnt hold any data because there is an error in its expression

I have an error in my visual like this,

I click the "see details" and the detail of the error is like this:

how this is happen?
I made [Month_] expression on Visual Studio, and there's no issue, no error and no exclamation mark in my expression. Can any one have an experience with this issue?

Thank you.

*this my [Month_] calculated column formula:
= IF(HRD[Years] = YEAR(TODAY()), IF(HRD[Year Month2]=MAX(HRD[Year Month2]),1,0),IF(HRD[month]=MAX(HRD[month]),1,0))

*this my [Year Month2] calculated column formula:

=HRD[Years]*100+HRD[month]

*Year it's just a year (example: 2020, 2021, 2022, etc.)

1 Reply

  • agustira97 , the Column Seems fine. Are you using direct query ?

     

    Can you share what exactly you are trying to achieve