Forum Discussion
Solved
Need Help with Creating Table from Four Different Datasets
I have 4 different excel dataset connected to power bi ,below are the example of different dataset. All are in different excel sheets and connected through sharepoint folder Month Rail Spen...
cyborgandy
Please refer to attched sample file and the following screenshots
Hi cyborgandy
what is the data type of the month columns?
you can have a date table or simply a month table that filters the four tables 1-*
the rest is just 4 simple measures (one for each metric table) like SUM ( 'Table'[Spend Column] )
use a matrix visual, place the month column from the dimension table at the columns of the matrix and activate the 'Values on rows" option
You need to create one to many relationships between the dimension table and the four tables.
cyborgandy
Please refer to attched sample file and the following screenshots
