Difference in Columns Using Values

[Sbudd]

Hi

Wondered if any of you can help me....Im trying to do a difference in columns 

My issue is im using a matrix, the columns headers are from a month in column and the Visits, Referrals and Sales are Values.

I would like 2 extra columns Diff and %Diff.

Is this even possible? Or do i need to create a new table?

Thanks in advance

[v-jingzhang]

Hi @Sbudd 

Can you provide some sample data in table format? Are the values fields (Visits/Referrals/Sales) columns or measures? And are the Diff and %Diff calculating the difference between two months?

It seems the matrix is showing values on rows. If you want Diff and %Diff to be two columns beside two months, you may need to prepare a new table with a different structure for this matrix. And create measures to calculate values.

Please provide some sample data we can work on. Thanks. 

Best Regards,
Community Support Team _ Jing

[amitchandak]

@Sbudd , you need to add measures like

example

diff = [MTD Sales]-[last MTD Sales]
diff % = divide([MTD Sales]-[last MTD Sales],[last MTD Sales])

using

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

Seem like you are looking for a hybrid table

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc