Forum Discussion

Advocate III

9 years ago

Solved

Multiple measures based on multiple date columns

How should I model this in Power BI? I need 4 measures that are dependent on different date columns. So far I have loaded the data into 4 different fact tables, which duplicates the dimension data, a...

Need Help

Anonymous
9 years ago
Hi GarryFarrell,

You can simply achieve your requirement on use unpivot data function, below is the sample:

Create table based on your screenshot:

Unpivot table:

Add measures:
Measure1 = SUMX(FILTER(ALLSELECTED('Dimension Item Unpivot'),'Dimension Item Unpivot'[Attribute]="Date1"),'Dimension Item Unpivot'[No of Items])
Measure2 = SUMX(FILTER(ALLSELECTED('Dimension Item Unpivot'),'Dimension Item Unpivot'[Attribute]="Date2"),'Dimension Item Unpivot'[No of Items])
Measure3 = SUMX(FILTER(ALLSELECTED('Dimension Item Unpivot'),'Dimension Item Unpivot'[Attribute]="Date3"),'Dimension Item Unpivot'[No of Items])
Measure4 = SUMX(FILTER(ALLSELECTED('Dimension Item Unpivot'),'Dimension Item Unpivot'[Attribute]="Date4"),'Dimension Item Unpivot'[No of Items])

Create visuals.
Table visual:

Slicer:

Card visuals:

Result:

Regards,
Xiaoxin Sheng