The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
18 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
12 | |
9 | |
8 |