Forum Discussion
Solved
Calculation Error in Measure
Hi, I have two graphs that look similar but are different. The first shows a target line of registrations with the current YTD registrations as a column below. It was changed to only show the...
Instead of VALUES('Date'[Date]) <= TODAY() you should use MIN('Date'[Date]) <= TODAY()
Thanks so much sdjensen !
Can you explain to me why it would work in one graph but on in the other? Want to understand so I can handle it myself in future.
Thanks!
It's because you use the formula in another context which cause VALUES to return more than one date which causes the error.