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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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