March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
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.
Try this ...yes you aggregate function..TRY THIS
IF(max('Calendar'[YearWeekNr]) < [Today (Week)], [Sales Value], [Forecast Value]) + 0
Try this ...yes you aggregate function..TRY THIS
IF(max('Calendar'[YearWeekNr]) < [Today (Week)], [Sales Value], [Forecast Value]) + 0
Hi @ribisht17
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?
https://community.powerbi.com/t5/Desktop/New-Measure-Cannot-find-name-from-table-column/m-p/2296157
Regards,
Ritesh
Hello @ribisht17
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?
Many thanks,
Dayna
In your case, you don't need RELATED, remove SELECTEDVALUE
IF(('Calendar'[YearWeekNr]) < [Today (Week)], [Sales Value], [Forecast Value]) + 0
Regards,
Ritesh
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
89 | |
72 | |
62 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |