Hi @Don Mill , Do you have one table or more than one? It looks like Holding Company is an entry in the Company column along with Company A, B, C and D. If it's just one table then you need 3 separate columns for Holding Co, Company and LOB. Alternatively ...
Hi @Andrew MacMath , If you want to just add the Care Manager to the table visual then you can write a measure to find it in the Discharges table. Something like: _Care Manager = CALCULATE( FIRSTNONBLANK( Discharges[Care Manager], TRUE() ), ...
Hi @Leonard Levine , From the Query editor, right click and create a new query with the Reference option. Repeat to create another new query. Right click again and uncheck the Enable Load option. This gives two queries that will load to the report ...
Hi, I am trying to copy several columns from one table to use in a new table where I plan to unpivot them. I have tried what i believe is every possible way to copy without success. The closest I came was to create a new (calculateed) table = to the ...
I got the solution with the change of Model. And also, more robust because, I can even compare the new indexes that are created on Azure. Created a DAX Table with Master Table = DISTINCT ( UNION ( SUMMARIZE ( Source, Source[table_view], ...
Have you heard of a Power BI SIG.. as in a special interest group? If your answer is No, that's OK. You're not alone. Power BI SIGs or Special Interest User Groups , are the hidden gems of the PUG community. Why? Because all you have to ...