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.
I have a small dataset (1115 rows, 5 columns) imported from SSMS.
All my query changes have been fine so far, but when I try to add a simply conditional column and try to apply, it will get stuck here
The steps are not complicated either:
Sorted by date then by category, renamed 2 of the columns, then added this conditional column with 1 'if' condition and an 'else' 'other' specification. The conditional column step makes it hang.
Solved! Go to Solution.
Well guys - yesterday it didn't work and today it did. I still don't know why, maybe the old pc needed a reboot. Thanks for your replies anyhow.
If someone runs into the same problem in the future I guess they could try a reboot first and then see if it works 😃
Well guys - yesterday it didn't work and today it did. I still don't know why, maybe the old pc needed a reboot. Thanks for your replies anyhow.
If someone runs into the same problem in the future I guess they could try a reboot first and then see if it works 😃
Your post says if...else...other. Just to clarify, do you use if ... then ... else , which is the expected M syntax?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I did not write the M code myself. I only used the dialog box that pops up below. So the code in the native query is just what PBI wrote for me.
Hi @DCELL ,
So your issue is solved ,right?
If so,could you pls mark the reply as answered to close it?
When you say SSMS do you mean SQL Server?
Where are you trying to add the column, in Power Query or in DAX?
Does your query support query folding or is that "Native Query" option greyed out?
Yes, SQL Server.
I'm trying to add it in Power Query, I don't know of a way to add it in DAX.
I didn't specify an SQL query in the advanced options when I imported. I can view the native query and see the full query fold and the lines of data where it put in the conditional column with a CASE statement:
select [_].[Yr] as [Yr],
[_].[MonthNo] as [MonthNo],
[_].[amt] as [amt],
[_].[gltr_domain] as [domain],
[_].[MonthEnd] as [Date],
[_].[Currency] as [Currency]
from
(
select [_].[Yr] as [Yr],
[_].[MonthNo] as [MonthNo],
[_].[amt] as [amt],
[_].[gltr_domain] as [gltr_domain],
[_].[MonthEnd] as [MonthEnd],
case
when [_].[gltr_domain] = 'usa'
then 'USD'
else 'Other'
end as [Currency]
from
(
select [_].[Yr],
[_].[MonthNo],
[_].[amt],
[_].[gltr_domain],
[_].[MonthEnd]
from [DATABASE].[TABLE] as [_]
) as [_]
) as [_]
order by [MonthEnd],
[gltr_domain]
run that same query in SSMS and check its performance.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |