Forum Discussion
SivaMani
7 years agoResident Rockstar
Matrix: Common variance column
Hello, I'm looking for a way to create a table like below, 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...
- 7 years ago
You may try the measure below.
Measure = IF ( HASONEFILTER ( Table1[Month] ), [Sales], [Variance] )
v-chuncz-msft
7 years agoCommunity Support
You may try the measure below.
Measure = IF ( HASONEFILTER ( Table1[Month] ), [Sales], [Variance] )
- SivaMani7 years agoResident Rockstar
It is not working. I'm facing the same issue like this when I create measure using another measure,