Forum Discussion

colin_dickson's avatar
colin_dickson
Frequent Visitor
3 years ago

Anual Budget Dataset

Hi,   I'm looking to create a static annual budget and use it for comparison purposes.   So my data is committment accounting and therefore is always a full year forecast split across multiple te...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  colin_dickson ,

 

You can create a separate table to act as a static budget

Here are the steps you can follow：

1. Enter data.

2. Create calculated column.

Variance =
ABS(
[Forecast Cost]
-
SUMX(
    FILTER(ALL(Table2),
    'Table'[Team] in SELECTCOLUMNS('Table2',"1",'Table2'[Team])&&
    'Table2'[Team]=EARLIER('Table'[Team])),
    'Table2'[Budget])
)

3. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly