Forum Discussion

jojo54's avatar
jojo54
Frequent Visitor
7 years ago
Solved

Start and end time

Hi there, pretty new to Power BI.  I'm trying to replicate something I do in Excel in Power BI, mainly because excel can't handle the amount of data that's being processed.   I'm trying to figure o...
Need Help
  • Geradav's avatar
    Geradav
    7 years ago

    Hi jojo54 

     

    See if the following can fix it for what you need

    Number of clients 2 =
VAR vMinVal =
    MIN ( TimeTable[Value] )
VAR vMaxVal =
    MAX ( TimeTable[Value] )
VAR vNumberOfClients =
    COUNTROWS (
        FILTER (
            ALLSELECTED ( ClientsTbl ),
            ClientsTbl[Entry Time] <= vMinVal
                && ClientsTbl[Exit Time] >= vMaxVal
        )
    )
RETURN
    vNumberOfClients

     

    Whenever I have more time I could think of something better.

Geradav's avatar
Geradav
Icon for Responsive Resident rankResponsive Resident
7 years ago

Hi jojo54 

 

See if the following can fix it for what you need

Number of clients 2 =
VAR vMinVal =
    MIN ( TimeTable[Value] )
VAR vMaxVal =
    MAX ( TimeTable[Value] )
VAR vNumberOfClients =
    COUNTROWS (
        FILTER (
            ALLSELECTED ( ClientsTbl ),
            ClientsTbl[Entry Time] <= vMinVal
                && ClientsTbl[Exit Time] >= vMaxVal
        )
    )
RETURN
    vNumberOfClients

 

Whenever I have more time I could think of something better.

jojo54's avatar
jojo54
Frequent Visitor
7 years ago

Geradav thank you!! That works perfectly!