Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Difference between MIN and current value for filtered incremental values

The dataset looks something like this and is only downloaded for a given month: data.energy location.circuit received 24026 total 10/08/2019 00:59 23906 total 09/08/2019 21:50 2258...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Create a calculate column using dax below:

    EnergyUsed = SWITCH(August[location.circuit], "total", August[data.energy] - 22000, "socket", August[data.energy] - 9900, "light", August[data.energy] - 2000)

     

     

    Community Support Team _ Jimmy Tao

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

     

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

Create a calculate column using dax below:

EnergyUsed = SWITCH(August[location.circuit], "total", August[data.energy] - 22000, "socket", August[data.energy] - 9900, "light", August[data.energy] - 2000)

 

 

Community Support Team _ Jimmy Tao

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks v-yuta-msft for picking this up. (Original this post was refused, so I had to submit it again and got an answer, see here: https://community.powerbi.com/t5/Desktop/Difference-between-MIN-and-current-values-based-on-filter-of/m-p/831557#M399442)

 

However, your solution would work, too (so I'll mark it), but it would be quite labour intensive, i.e. every month when I download a new dataset, I would need to manually figure out the mininmum for each location.circuit....