I have an if statement, where I want to show Sales Value when the weekyearnr is less than the current week. Otherwise, use the Forecast Value.
In my QlikView past I'd do:
IF('Calendar'[YearWeekNr]) < [Today (Week)], [Sales Value], [Forecast Value])
In PowerBI, this seems to work when looking at all values:
Solved! Go to Solution.
I assumed that too originally, but unless my syntax is wrong, it says it cannot find the field 'Calendar'[YearWeekNr]
It is written the same way as what you've listed on your message. Using something like SELECTEDVALUE then renders it fine.
I do get a little lost with syntax when referencing a measure compared to that of a field in a table, so it may be something obvious I've not done!
Looking at this thread, I need an aggregation function to use column fields?
Thank you for your response, I've tried but I don't think I fully understand how to use RELATED in this example. You're quite rght that I'm not looking to read the current filter context, but rather the row values.
How would RELATED work in my example where I'm evaluating the value of each column to a measure?
In your case, you don't need RELATED, remove SELECTEDVALUE
IF(('Calendar'[YearWeekNr]) < [Today (Week)], [Sales Value], [Forecast Value]) + 0