Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Giuseppe_a97
New Member

Power bi desktop function (representation)

Hi, I've a Bi desktop problem that I can't fix. I've a table with the following columns: number of train, train maintenance facility, time of departure from station "x", time of arrival at station "y" and I would like to represent in a graph or in a table for each maintenance facility the total number of trains in operation at different times of the day.  Thanks to anyone who can give me a hand

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Giuseppe_a97 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

 

If you post sample data can be more specific.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler thanks for the answer, but I can't fix yet. I try to post a simple example:

 

maintenance facility --- Departure hour --- Arrival hour --- train

Milano                            07.00                      12.00                  CA7183

Roma                              09.00                      13.00                  AX9283

Napoli                            14.00                       20.00                  BY3273

Milano                            12.00                       21.00                  CI8213

Milano                            12.30                       14.00                  AM1324

Roma                              18.00                       19.00                  OH1132

 

Now the question is: how many trains of the Milan maintenance facility are in operation from 9 to 15?

I would like to have a table/graph that show me this information

 

Thanks

  

@Giuseppe_a97 Use a disconnected time table with the hours you want to track and this measure. PBIX is attached below signature.

Measure = 
    VAR __Table = 
        SELECTCOLUMNS(
            FILTER(
                GENERATE(
                    'Table',
                    'Times'
                ),
                [Hour] >= [departure hour] && [Hour] <= [arrival hour]
            ),
            "Train",[train],
            "Hour",[Hour]
        )
    VAR __Table1 = GROUPBY(__Table, [Train], "Count", COUNTX(CURRENTGROUP(),[Hour]))
    VAR __Result = COUNTROWS(__Table1)
RETURN
    __Result

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors