Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!