Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Year on Year Difference

Hi @all, Is it possible to create a measure to find variance in PowerBI like below?  
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

You are welcome.  There should be another closing bracket before the - sign and remove one closing bracket from he end.

If it still does not work, then share the download link of the PBI file.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ashish,
The modified formula did work but unfortunately didn't achieve what was actually expected.
Rows: ValDate (i.e Dec & June)
Columns: Fiscal Year (FY23, FY24,....)
Value: Net Debt(measure) , Net Debt Variance