Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi all,
I have a client masterfile table included in my data model. The table is linked in DirectQuery mode from a SQL Server. In the table query I have added some lines to mock up the data but when I try to replace values in a column based on condition I fail and get the following message:
This is the step I need to do:
= Table.ReplaceValue(#"Filtered Rows", each [Group], each if [Group] = "” then [Company] else [Group], Replacer.ReplaceValue, {"Group"})
Practically I need to have all cells in column Group filled either with the preexisting value or with the value present in the Company column (both text fields)
I can't believe this is not possible in DirectQuery mode. What am I doing wrong?
Thanks,
C.
Hi there, thanks for your reply.
I did actually try the first method above and it did not work. After adding the new column I couldn’t populate it conditionally and got the same message. I will try the second solution (If I can find the way). At the end if nothing works I will accept the import mode but we are talking about a very large table to be possibly used in several reports and would be a real waste of space.
Many thanks indeed; I will let you know how it goes.
Regards,
C.
@Anonymous,
One approach would be to add a custom column in Power Query with the "if" statement, and then remove the original column Group. You could also use custom SQL with a CASE statement. With custom SQL, you'll need to put all transformations in the SQL (no M transformations).
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
57 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
56 | |
46 | |
40 |