Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
So I'm trying to build a DAX expression to register the binary #s (O,P,Q columns) into specifc text (R column):
I wrote the following code but its giving me an error:
It's saying the expressions that yield variant data-type cannot be used to define calculated columns.
Any insights in how I can fixt this?
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
Forecast Status CC =
IF (
'Analysis 3'[overforecast] = 1,
"Over forecast",
IF (
'Analysis 3'[underforecast] = 1,
"Under forecast",
IF ( 'Analysis 3'[on target] = 1, "On target", "0" )
)
)
Hi,
Please check the below picture and the attached pbix file.
Forecast Status CC =
IF (
'Analysis 3'[overforecast] = 1,
"Over forecast",
IF (
'Analysis 3'[underforecast] = 1,
"Under forecast",
IF ( 'Analysis 3'[on target] = 1, "On target", "0" )
)
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |