Forum Discussion
Creating a table with three different distinct excels that has the only common data is date.
Hi, Thanks in advance Help me to reach a connection model between 3 distinct excels that has only data as common source. Basically the dashboard should look like the below and everyday I will b...
Anonymous
Based on the expected output and provided data sample. I would suggest you to add a new 'Source' column in all three excel files which signifies whether the data is from Target/Finalized/Created report data.
Then load these three tables into power bi and append them. then you will be able build a matrix visual. Add date column into rows field, Patient and source into columns and count measure into values field.
Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun