Forum Discussion
SQL Server and PowerBI DirectQuery mode
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 w...
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).