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.
Hi,
Below Switch statement works for me but I need to include else then the result is a text value.
So
If 'powerbi114 cmQualifications'[qualificationId] = 3892 or 4036 or 4038 then
Expiry Date = "Does not Expire"
Anyway I can modify below Switch to include this?
Solved! Go to Solution.
Hi @Qotsa
Sorry, my bad, all your conditions result in number and your else is text.
You will need to convert all the values you return to text using CONVERT() or FORMAT( 1, "") or return number in ELSE condition
Hi @Qotsa
Else is the last argument like
Expiry Date =
SWITCH(
TRUE(),
'powerbi114 cmQualifications'[qualificationId] = 3892,DATEADD('powerbi114 cmQualifications'[awardDate].[Date],3,YEAR),
'powerbi114 cmQualifications'[qualificationId] = 4036,DATEADD('powerbi114 cmQualifications'[awardDate].[Date],2,YEAR),
'powerbi114 cmQualifications'[qualificationId] = 4038,DATEADD('powerbi114 cmQualifications'[awardDate].[Date],3,YEAR),
"ELSE SOMTHING")
Thanks for reply.
I should have said I tried that but getting this error - Expressions that yield variant data-type cannot be used to define calculated columns.
Hi @Qotsa
Sorry, my bad, all your conditions result in number and your else is text.
You will need to convert all the values you return to text using CONVERT() or FORMAT( 1, "") or return number in ELSE condition
Perfect. Thank you.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |