Forum Discussion

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

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.

wynhopkins

Most Valuable Professional

7 years ago

Nice approach mussaenda , why use the 20 in List.Times?

Also, jojo54 , given this code will work in Excel I'd be interested to know what performance issues your having that you're trying PowerBI. Is it the 32 Bit Excel version that's limiting you?

Wyn