Forum Discussion

jaladurgam's avatar
jaladurgam
Regular Visitor
8 years ago

Deduping data at higher levels

Hi  Everyone   I'm new to Power BI and DAX, hence finding one issue as a bottle neck for my analysis. I have the data like in the below table   Person     Region      District     Territory      ...
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

I assume that the example you posted is describing the desired output, correct?
How does the the raw data input look like? could you share the examples of the tables?

jaladurgam's avatar
jaladurgam
Regular Visitor
8 years ago

Hi Stachu,


Thanks for your reply

 

I have a dimension table (Geography) and fact table Sales as below..

 

Dim_Geo              Sales

Geo_Key

Region

District

Territory