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

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, MrGriff 

    Thank you for your feedback.

    Can you tell me which date / which area / which location / which factory information do you want to show in card visualization? Without selecting the criteria, I do not know what to show.

    Or, please describe what is your desired outcome.

    Thank you.

    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