Forum Discussion

VikramAdi's avatar
VikramAdi
Helper 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
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi VikramAdi 
This can never be achieved with a single table data model. Please refer to attached sample file with the proposed solution

 

Diff Quantity = 
VAR Value1 = CALCULATE ( SUM ( Data[Quantity] ), ALL ( Scenario1 ), ALL ( Period2 ) )
VAR Value2 = CALCULATE ( SUM ( Data[Quantity] ), ALL ( Scenario2 ), ALL ( Period2 ) )
RETURN
    Value2 - Value1
Diff Sold = 
VAR Value1 = CALCULATE ( SUM ( Data[Sold] ), ALL ( Scenario1 ), ALL ( Period2 ) )
VAR Value2 = CALCULATE ( SUM ( Data[Sold] ), ALL ( Scenario2 ), ALL ( Period2 ) )
RETURN
    Value2 - Value1
Diff Amount = 
VAR Value1 = CALCULATE ( SUM ( Data[Amount] ), ALL ( Scenario1 ), ALL ( Period2 ) )
VAR Value2 = CALCULATE ( SUM ( Data[Amount] ), ALL ( Scenario2 ), ALL ( Period2 ) )
RETURN
    Value2 - Value1