Forum Discussion
Consolidating source multiple rows into 1 row
Hi all, looking for some helpful hints to point me in the right direction for combining multiple incoming transactional rows for an ID into 1 output row to be used for reporting. Each row is ide...
Try first nonblank for Salesperson, sales Area code
https://docs.microsoft.com/en-us/dax/firstnonblank-function-dax
Create a matrix view with row as ID
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601