Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Dear Power BI community,
I have the following problem and I can not find my way out...
For each sequence number, I have the number of people that enter the system and the number of people that the system has the capacity to process (output), so if input<output then the queue is ZERO, else the amount of the queue will be Queue(n-1) + Input - Output, as the print shows below.
I need to replicate this excel calculation in a DAX function to calculate the number of people waiting in the queue.
Any idea if it is feasible and how to proceed?
Many thanks in advance for your help
Solved! Go to Solution.
Hi
I think there is a simple w<ay to write it but I did not find it.
Anyway, first I added a column to your table. Input-Output
and after I wrote this measure
Hi
I think there is a simple w<ay to write it but I did not find it.
Anyway, first I added a column to your table. Input-Output
and after I wrote this measure
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
15 | |
10 | |
8 | |
8 | |
7 |