Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Include change from year end in measure's matrix line

I have a matrix displaying multiple measures by month and dimension, like this one:

 

Fruit

 

Dec-19

Jan-20

Feb-20

Mar-20

Apr-20

May-20

Jun-20

Jul-20

Apple

 

 

 

 

 

 

 

 

 

 

Measure1

100

101

102

103

104

105

106

107

 

Measure2

210

209

208

207

206

205

204

203

Banana

 

 

 

 

 

 

 

 

 

 

Measure1

50

51

52

53

54

55

56

52

 

Measure2

150

149

148

147

146

145

144

148

 

I'd like to add the comparison to the beginning of the year and the last month in the same table:

 

Fruit

 

Dec-19

Jan-20

Feb-20

Mar-20

Apr-20

May-20

Jun-20

Jul-20

vs Dec 2019

vs Last Month

Apple

 

 

 

 

 

 

 

 

 

 

 

 

Measure1

100

101

102

103

104

105

106

107

7

1

 

Measure2

210

209

208

207

206

205

204

203

-7

-1

Banana

 

 

 

 

 

 

 

 

 

 

 

 

Measure1

50

51

52

53

54

55

56

52

2

-4

 

Measure2

150

149

148

147

146

145

144

148

-2

4

 

Is there a way to do this?

I'm able to have them in 2 separate tables but the UX is really bad.

Any help is appreciated.

Kind regards,

Jon

 

 

1 REPLY 1
amitchandak
Super User
Super User

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.