Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In the table below, the column 'final result' is the new column that I need to produce from columns 'unit' and 'result'. The rules for creating 'final result' are:
Question: What is the DAX script to produce the column 'final result'?
Thanks in advance
Solved! Go to Solution.
Hi @pmcinnis
try a new calculated column
final result = SWITCH(TRUE(),
'Table'[unit]="x",1000*'Table'[result],
'Table'[unit]="y",'Table'[result],
'Table'[unit]="z",'Table'[result]/1000,
ISBLANK('Table'[unit]) && ISBLANK('Table'[result]),BLANK(),
ISBLANK('Table'[unit]) && ISNUMBER('Table'[result]),'Table'[result],
"Undefined"
)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi @pmcinnis
try a new calculated column
final result = SWITCH(TRUE(),
'Table'[unit]="x",1000*'Table'[result],
'Table'[unit]="y",'Table'[result],
'Table'[unit]="z",'Table'[result]/1000,
ISBLANK('Table'[unit]) && ISBLANK('Table'[result]),BLANK(),
ISBLANK('Table'[unit]) && ISNUMBER('Table'[result]),'Table'[result],
"Undefined"
)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Thanks, that worked great. What is the purpose of the TRUE function near the beginning of the script?
SWITCH syntax is
SWITCH(<expression>, <value1>, <result1>, <value2>, <result2>, <else>)
in the most common case as expression used Column.
it works as follow:
First, value1 compares with expression. if equals = result`, if not - goes to value2 and so on.
As you have more sophisticated condition in values, you can not to compare it with the only column. So, TRUE() allows you to compare complex conditions with true(), like if
ISBLANK('Table'[unit]) && ISBLANK('Table'[result]) = TRUE()
then return desired result
do not hesitate to give a kudo to useful posts and mark solutions as solution
Ah, I see, thanks for clarifying!
Thanks for the quick reply, let me look into this
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |