Columns Seriaes

[shaya]

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])

[MFelix]

Hi @shaya,

You need to place your DimPeriod in the columns and the measure in values.

Should give what you want.

Regards,

MFelix

[shaya · Accepted solution]

Thanks MFelix

In Excel there in the column, how do I enter in the column in POWER BI

[shaya]

Thanks

I found the solution here

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-tables/