Forum Discussion
agustira97
3 years agoFrequent Visitor
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
- amitchandak
Super User
agustira97 , the Column Seems fine. Are you using direct query ?
Can you share what exactly you are trying to achieve