Forum Discussion

MrGriff's avatar
MrGriff
Frequent Visitor
5 years ago
Solved

Daily Increase problem

I have multiple meters that I can see and show how much they have gone up by as below, to get the daily value I need to subtract the max of the day for the min for the day; Factory Location ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, MrGriff 

    Please check the below picture and the sample pbix file's link down below.

    If I may suggest, I prefer to have date column and time column separately.  Because in case there is time-based analysis is needed, it is more efficient.

    Even if you do not split it for this time, you can still try to write something similar to the below.

     

     

    Active Energy Delivered =
    VAR currentdate =
    MAX ( 'Calendar'[Date] )
    VAR currentarea =
    MAX ( Data[Area] )
    VAR currentlocation =
    MAX ( Data[Location] )
    VAR currentfactory =
    MAX ( Data[Factory] )
    VAR startlevel =
    CALCULATE (
    SUM ( Data[_VALUE] ),
    FILTER (
    ALLSELECTED ( Data ),
    Data[Time] = MIN ( Data[Time] )
    && Data[Date] = currentdate
    && Data[Area] = currentarea
    && Data[Location] = currentlocation
    && Data[Factory] = currentfactory
    )
    )
    VAR endlevel =
    CALCULATE (
    SUM ( Data[_VALUE] ),
    FILTER (
    ALLSELECTED ( Data ),
    Data[Time] = MAX ( Data[Time] )
    && Data[Date] = currentdate
    && Data[Area] = currentarea
    && Data[Location] = currentlocation
    && Data[Factory] = currentfactory
    )
    )
    RETURN
    endlevel - startlevel
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

MrGriff 

maybe you can try to create a date column

DATE = INT('Table'[_TIMESTAMP])

then create a measure

Measure = 
var _MIN=CALCULATE(MIN('Table'[_TIMESTAMP]),ALLEXCEPT('Table','Table'[Area],'Table'[Factory],'Table'[Line],'Table'[Location],'Table'[DATE]))
VAR _MAX=CALCULATE(MAX('Table'[_TIMESTAMP]),ALLEXCEPT('Table','Table'[Area],'Table'[Factory],'Table'[Line],'Table'[Location],'Table'[DATE]))
RETURN MAXX(FILTER('Table','Table'[_TIMESTAMP]=_MAX),'Table'[_VALUE])-MAXX(FILTER('Table','Table'[_TIMESTAMP]=_MIN),'Table'[_VALUE])

please see the attachment below