Matrix: Common variance column

Question

Hello,&nbsp;I'm looking for a way to create a table like below,NameCustomer IDSales NoProductJan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18VarianceAC1S1X10911199112510731036106610321195163BC2S2Y1120101611941059100210021063111653CC3S3Z10461035111510021126114010361007-29&nbsp;&nbsp;I tried matrix visual,Rows - Name CustomerID, Sales No and ProductColumns - MonthValues - Sales and Variance&nbsp;Unfortunately the visual shows variance for every month.&nbsp;&nbsp;&nbsp;Is there any way to attain this?

v-chuncz-msft · Accepted Answer

SivaMani,
&nbsp;
You may try the measure below.
Measure =
IF ( HASONEFILTER ( Table1[Month] ), [Sales], [Variance] )

Forum Discussion

Matrix: Common variance column

2 Replies

Related content

Budget, actual and variance matrix

Simple Matrix with Variance

Multiple variance calculation in matrix

Add Variance Column to Matrix

Variance Matrix based off slicer selection

Name	Customer ID	Sales No	Product	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Variance
A	C1	S1	X	1091	1199	1125	1073	1036	1066	1032	1195	163
B	C2	S2	Y	1120	1016	1194	1059	1002	1002	1063	1116	53
C	C3	S3	Z	1046	1035	1115	1002	1126	1140	1036	1007	-29