calculate % of diff in power bi

[NISHA_S]

This is an sample excel data.Here , for the third column (% of Diff) is calculated based on formula (B2-B1)/(B1).How we can calculated this column in Power bi,If i have first and second column in power bi?

[v-xulin-mstf]

Hi @NISHA_S,

Sorry, i'm not sure about the calculation logic of '(B2-B1)/(B1)'.

Could you provide more details?

Best Regards,

Link

[amitchandak]

@NISHA_S , if you do not have date , create a date column like

Date = "01 " & [monthly] //change datatype to date.

Then join ith with date table and try measures like

MTD = CALCULATE(Average(Table[Value]),DATESMTD('Date'[Date]))
last MTD = CALCULATE(Average(Table[Value),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month = CALCULATE(Average(Table[Value),previousmonth('Date'[Date]))

diff = [MTD]-[last MTD]
diff % = divide([MTD]-[last MTD],[last MTD])