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
thomaskelly
Helper I
Helper I

Create a Calculated Column in a matrix

Hello,

 

I have connected power Bi to an azzure db and have been reasonably successful so far in compiling a dashboard with numerous graphs and tables. However I have now reached a hurdle that has me totally stumped and would welcome some assistance.

 

I have 3 years of data in a table related to sales invoices all with a invoice date column and an invoice amount column as well as other information. I have  created a matrix in power Bi that can be filtered  by way of a slicer to ( for example) the month of august 2016 and august 2015 to compare product category sales for those filtered months. What I want is to be able to add an additional column beside these two that recalculates when the matrix is filtered to other months for example January 15 vs January 16.  I want this column to calculate the % variance between the rows of data in the matrix which is related to product category sales.

 

Can anyone help? Is there a way of doing this ?

 

Any thoughts would be most appreciated

 

Many Thanks

2 ACCEPTED SOLUTIONS

I am not really sure if there is an easier way. I have two date tables which I use as slicers allowing me to select two periods to compare and then I have a master date table where I create my calculations, e.g. sales for period 1 and sales for period 2

 

Hope this makes sense and apologies if I have misunderstood what you are trying to do.

 

Edit: I have attached a screenshot of how my matrix looks if that helps.Capture.PNG


Shona

 

 

View solution in original post

Hi Shona

 

Thanks for that Smiley Happy

 

I  have managed to do it by creating a seperate date table then by creating a previous year measure and % change measure. When I now select my required month by way of a filter it will show this month for the current year and the previous year coloum will filter to show the sales for that period last year and the % variance between these two months.

 

Thanks for your help...

 

 

View solution in original post

10 REPLIES 10

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.