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

[agustira97]

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.)

[amitchandak]

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

Can you share what exactly you are trying to achieve