Forum Discussion
SIMPLE? - data modeling question
Hello, I am newer to PowerBI so I appreciate any help. My desired end state is a table with one row per client and one column per documentation type. In the respective documentation type columns, ...
Hi Still-Learning ,
If you want to visual it as a table, we can just put the date in filed and set it summarize as latest date:
If you want to get a actual table, we can create a calculated table as following:
Calculated Table = SUMMARIZE('Table','Table'[Client],'Table'[Document Type],"MaxDate",MAX('Table'[Date of Document]))
Or create the table in power query editor by using group by:
If it doesn't meet your requirement, Could you please show the exact expected result based on the tables that you have shared?
By the way, PBIX file as attached.
Best regards,