Forum Discussion
help in dax
Need help in calculating the delta( IN SAME matrix table below) between 2020H1 and 2019 H2 from the below matrix
I have columns like
Year: 2019, 2020
Bundle name : Mobility, Mathworks
Half year: H1, H2
Cost: the values in K
On expanding the bundles, will have employee name.
Hi Anonymous
Create a measure
Measure = VAR diff = CALCULATE ( SUM ( 'Table 2'[value] ), FILTER ( 'Table 2', 'Table 2'[year] = 2020 && 'Table 2'[half year] = "h1" ) ) - CALCULATE ( SUM ( 'Table 2'[value] ), FILTER ( 'Table 2', 'Table 2'[year] = 2019 && 'Table 2'[half year] = "h2" ) ) RETURN IF ( ISINSCOPE ( 'Table 2'[year] ), SUM ( 'Table 2'[value] ), diff )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , not very clear of the on what is the issue. You can half year in you calendar.
And this display can be a matrix
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
v-juanli-msftCommunity Support
Hi Anonymous
Create a measure
Measure = VAR diff = CALCULATE ( SUM ( 'Table 2'[value] ), FILTER ( 'Table 2', 'Table 2'[year] = 2020 && 'Table 2'[half year] = "h1" ) ) - CALCULATE ( SUM ( 'Table 2'[value] ), FILTER ( 'Table 2', 'Table 2'[year] = 2019 && 'Table 2'[half year] = "h2" ) ) RETURN IF ( ISINSCOPE ( 'Table 2'[year] ), SUM ( 'Table 2'[value] ), diff )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
