Forum Discussion
Columns Seriaes
There is a nice example that shows the columns by Pivot table, how do I display it in Power Bi
Thanks
The measure:
PeriodSales:=IF( COUNTROWS( VALUES( DimPeriod[Period]))=1,
IF( VALUES( DimPeriod[Period]) = "Current", [Sales],
IF( VALUES( DimPeriod[Period]) = "MTD", [Sales](DATESMTD(DimDate[Datekey])),
IF( VALUES( DimPeriod[Period]) = "QTD", [Sales](DATESQTD(DimDate[Datekey])),
IF( VALUES( DimPeriod[Period]) = "YTD", [Sales](DATESYTD(DimDate[Datekey])),
IF( VALUES( DimPeriod[Period]) = "LastYear", [Sales](DATEADD(DimDate[Datekey],-1,YEAR)),
IF( VALUES( DimPeriod[Period]) = "PriorYearMTD", [Sales](DATEADD(DATESMTD(DimDate[Datekey]),-1,YEAR)),
IF( VALUES( DimPeriod[Period]) = "PriorYearQTD", [Sales](DATEADD(DATESQTD(DimDate[Datekey]),-1,YEAR)),
IF( VALUES( DimPeriod[Period]) = "PriorYearYTD", [Sales](DATEADD(DATESYTD(DimDate[Datekey]),-1,YEAR)),
BLANK())))))))),[Sales])
- Anonymous8 years ago
Thanks MFelix
In Excel there in the column, how do I enter in the column in POWER BI
3 Replies
- MFelixSuper User
Hi Anonymous,
You need to place your DimPeriod in the columns and the measure in values.
Should give what you want.
Regards,
MFelix
- AnonymousNot applicable
Thanks MFelix
In Excel there in the column, how do I enter in the column in POWER BI
- AnonymousNot applicable
Thanks
I found the solution here