Forum Discussion

Viswajth_Nair95's avatar
Viswajth_Nair95
Frequent Visitor
4 years ago
Solved

Adding a value to 2 rows based on 1 row

So, i have a table like this which has the energy consumption reading for different energy type.    When there is a shutdown in the plant, the gas reading drops immediately, so whenever the g...
DAX
Power Query
PowerQuery
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Viswajth_Nair95 
    Please refer to sample file with the solution https://www.dropbox.com/t/87UNh6OAhZDbijhM

    SD = 
IF (
    CALCULATE ( 
        SELECTEDVALUE ( EnergyConsumption[Energy] ),
        EnergyConsumption[EnergyType] = "Gas",
        ALLEXCEPT ( EnergyConsumption, EnergyConsumption[Date], EnergyConsumption[Time] )
    )
        < 3,
    1
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Viswajth_Nair95 
Please refer to sample file with the solution https://www.dropbox.com/t/87UNh6OAhZDbijhM

SD = 
IF (
    CALCULATE ( 
        SELECTEDVALUE ( EnergyConsumption[Energy] ),
        EnergyConsumption[EnergyType] = "Gas",
        ALLEXCEPT ( EnergyConsumption, EnergyConsumption[Date], EnergyConsumption[Time] )
    )
        < 3,
    1
)