cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
New Member

@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

Super User

@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``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...