Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
Shona
Hi Shona
Thanks for that
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...
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |