cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Geradav Regular Visitor
Regular Visitor

Re: Start and end time

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

Annotation 2019-08-09 120930.jpg

 

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

View solution in original post

jojo54 Frequent Visitor
Frequent Visitor

Re: Start and end time

@Geradav thank you!! That works perfectly!

jojo54 Frequent Visitor
Frequent Visitor

Re: Start and end time

hi there, I'm now trying to add an extra column of information which shows which company the person is from.  However when I try to apply a page filter to filter for individual companies, the command seems to still be looking through the whole table and not filtering the count only for that company. Any ideas how to fix it?

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)