Forum Discussion

VikramAdi's avatar
VikramAdi
Icon for Helper II rankHelper II
3 years ago

How to calculate differnce between 2 comaprision table columns

Table 1 and table 2 currently using for comapre same data at a time, using edit interctions, i stoped interctions with table 1 and table 2. now i am able to compare data. I am having another r...
@Dax
@Dax help
@measure
@NeedHelp
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi VikramAdi you can create 3 measures as shown below, and organize table as shown on picture below.

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

 

Diff Quantity =
VAR _actual=CALCULATE( SUM(Data[Quantity]),Data[Scenario]="Actual")
VAR _FC=CALCULATE( SUM(Data[Quantity]),Data[Scenario]="Fcast")
VAR _result=_actual-_FC
RETURN _result
 
Diff Sold =
VAR _actual=CALCULATE( SUM(Data[Sold]),Data[Scenario]="Actual")
VAR _FC=CALCULATE( SUM(Data[Sold]),Data[Scenario]="Fcast")
VAR _result=_actual-_FC
RETURN _result
 
Diff Amount =
VAR _actual=CALCULATE( SUM(Data[Amount]),Data[Scenario]="Actual")
VAR _FC=CALCULATE( SUM(Data[Amount]),Data[Scenario]="Fcast")
_result=_actual-_FC
RETURN _result