Measure Formula Help

[Krishnan_47]

Hi All,

I need help in creating a measure. I have used excel to display the formula. Please find below screenshot where formula is highlighted in yellow.

Column A and B is loaded into Power BI.

Values should come as in Column C based on the formula present in Column D.

The challenge in this formula is that we need to use the measure within the measure. In this example, we can call Column B in the formula but I have no idea how to get previous month value in column C.

 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[manikumar34]

@Krishnan_47 ,

Try below measure. 

Measure =

VAR pp = CALCULATE(SUM('Table'[Excess Return]),PREVIOUSMONTH('Table'[Date]))

VAR cp=SUM('Table'[Excess Return] )

RETURN

(pp+100)*(1+cp)-100