How calculate month growth in euros comparing with last month also in percent in Power BI?

[Analitika]

Hi,

I need to calculate sales growth in euros and percentage comparing it with last month. How to achieve this?

[piotr_gor]

Measure = 
VAR _ThisMonthSales = [Sales Amount]
VAR _LastMonthSales = CALCULATE ( [Sales Amount], PREVIOUSMONTH ( 'Date'[Date] ) )
VAR _Difference = _ThisMonthSales - _LastMonthSales 
VAR _Result = DIVIDE ( _Difference, _LastMonthSales )
RETURN
    _Result 

[Kishore_KVN]

Hello @Analitika ,

Follow below steps to achieve your requirement. 

1. select the sales amount column and change the format to Euro in the column tools. 

2. Create a calendar table, then connect it with the fact table. 

3. Create two measure one for current month and another for previous month

       Current Month = sum(sales amount)

       Previous Month  = Calculate(sum(sales amount),previousmonth(calendar[date]))

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!