How to perform the % of the difference function of (previous or later) PivotTables with Power Bi.

[Syndicate_Admin]

I need to set the percentage difference with the previous value of the same column. I have some data only by week number (they do not have date format) and I have to make the difference with the value of the previous week. With pivot table is done in a moment, the option % of the difference in .... name of the Base Week field and Previous Base Element and we already have the difference with the previous week. I can't do it easily with Dax in Power Bi.

If anyone can help me I would appreciate it. Greetings.

[tamerj1 · Accepted solution]

Hi Admin @Syndicate_Admin , @Xavier2609 

this option is not available in power bi neither in power pivot. Only in standard pivot table. Iin both power bi and power pivot you need to write the dax code manually. I will assume the numbers to left are week numbers. Seems this column is formated as text because it is aligned left. So please first make sure it is formatted as whole number.  Then you can create a new measure 

DIVIDE ( 

SUM ( TableName[ColumnName] ),

CALCULATE ( SUM ( TableName[ColumnName] ),, TableName[Week Number] = MAX ( TableName[Week Number] ) - 1 )

)

[Syndicate_Admin]

Perfect solution, many gràcias.