Forum Discussion
cyborgandy
Helper II
Helper IINeed 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
tamerj1
Community Champion
Community ChampionHi 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
cyborgandy- tamerj1
You need to create one to many relationships between the dimension table and the four tables.
- tamerj1
cyborgandy
Please refer to attched sample file and the following screenshots