Calculate variance
Budget: €8 – €30 EUR
Have created an excel file with a data model containing actual and budget columns from 2 separated tables. I would like to add a new calculated columns (i guess using DAX formulas) in order to get variance numbers (actual vs budget amount and actual vs budget %.. Need help on the 2 calculated columns. Also any other additions that might be better for such spreadsheet
-Data model is already created
-Data model is already created