Diff between values same column, based on value from another column NOT DATE

[Anonymous]

Hellos community,

New here. I am trying with no success with calculate to make variance of values. Actual vs Budget, Actual vs Forecast and Actual vs Previous Year. 

All data is in the same column and there are a column for date and other for type of value (forecast, actual or budget). See picture below. 

how can I do that?

[Ahmedx · Accepted solution]

or if you do not want transformation your table, then you need to write the following measures:

BUDGET = CALCULATE(SUM('Table'[ VALUE]),'Table'[VALUE TYPE]="BUDGET")
FORECAST = CALCULATE(SUM('Table'[ VALUE]),'Table'[VALUE TYPE]="FORECAST")
ACTUAL =  CALCULATE(SUM('Table'[ VALUE]),'Table'[VALUE TYPE]="ACTUAL")

[Ahmedx]

You first need to transformation your table for this, see my video, and then you can create simple measures
https://1drv.ms/v/s!AiUZ0Ws7G26Rh0DmynvfwdeQja5G?e=d7efBH

[Anonymous]

Thanks a lot Ahmedx