How Show Date (Months and Years) Variance and % Variance of revenue ?

[newton80]

Hi!

Im new with Microsoft PowerBi and im rapidly learning this tool.

I have a big and typical question:

Im creating a new Report. I have data as in the sheet i have showed. So as its possible see, i have a data column (Ac.Gi date) and X, Y. X and Y are 2 revenue columns. I need to compare Month by Month of 2015 and 2016 for x and y. I want to see, for example, so how X (total) values change 1/2015 -> 1/2016 and the % variance.

Can anyone explain to me how i could using Dax or a native PowerBi solution ?

Thank u!

Ac.GI date	Anno	Month	X	Y
04.01.2016	2016	1	34.00	260.00
04.01.2016	2016	1	32.00	205.50
05.01.2016	2016	1	32.00	205.50
04.01.2016	2016	1	26.00	468.39
04.01.2016	2016	1	34.00	40.00
04.01.2016	2016	1	34.00	40.00
04.01.2016	2016	1	34.00	40.00
05.01.2016	2016	1	32.00	420.00
05.01.2016	2016	1	34.00	720.00
05.01.2016	2016	1	33.00	270.00
05.01.2016	2016	1	34.00	641.90
07.01.2016	2016	1	32.00	270.00
07.01.2016	2016	1	33.00	420.00
05.01.2016	2016	1	18.00	512.53
05.01.2016	2016	1	15.00	362.47
08.01.2016	2016	1	33.00	715.00
08.01.2016	2016	1	33.00	715.00
08.01.2016	2016	1	32.00	800.00
08.01.2016	2016	1	32.00	800.00

[v-ljerr-msft]

Hi @newton80,

The measures provided by smoupre above should work, just note that most of the time intelligence functions require a standard Date table to work correctly. If you don't have the Date table yet, you can use CALENDAR function to create the Date table. 

Here is a similar thread for your reference.

Regards

[Greg_Deckler]

You will need a date table most likely and then you can do something like the following measures:

SumX = SUM([X])

Last Year SumX = CALCULATE ([SumX], SAMEPERIODLASTYEAR ('Date'[Date]))

% Variance = ([SumX - [Last Year SumX])/[Last Year SumX]