The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
How can I determine the first intance the running total is less than or equal to 0?
In this case I want the result to be 6.
As its the first week that is non-zero.
Thank you!
Solved! Go to Solution.
Hi,
This measure works
Measure = COUNTROWS(FILTER(VALUES('Resource Priority'[RT Good Week]),[10K 2PLD RT]>0))+1
Hope this helps.
Hi,
Why should the answer be 6?
That is the first instance when the RT is <0. In your original post, you mentioned that you wanted to know the first instance when the RT is >0.
You are correct, I mispoke. I'll fix it in the original request.
Share the download link of the PBI file with the RT measure already written.
I'll need the file.
Sorry, stupid question. How do I share it?
Google Drive/One Drive.
Google Drive It Is
Hi,
This measure works
Measure = COUNTROWS(FILTER(VALUES('Resource Priority'[RT Good Week]),[10K 2PLD RT]>0))+1
Hope this helps.
Works, for counting ALL dates less than or equal to zero.
BUT, I'm looking for the number of weeks to the FIRST and only the FIRST negative value.
https://drive.google.com/file/d/1BnqZDDm8UjoIObpoM-m5tWv31EwLx-K6/view?usp=sharing
I do nto understand your expected result. Show that very clearly.
I'm trying to figure out the periods of time (weeks) to the green box of each running total.
For the Wide RT column. Your formula is returning 3. It should be 1 as the frist row is negative.
I listed the correct answer in green below the "Lead Time - Weeks" table.
Hi,
I can try but before that you will need to create a Calendar Table in the file with a week column in there. Create a relationship (Many to One and Single) from the Good Build Date column to the Date column of the Calendar Table. Share the download link of the revised PBI file.
Does this reply above make sense Ashish?
This YouTube video is a really close solution, but my Running Total is a measure.
So CALCULATEDTABLE(VALUES (Sales[Order Date]), ALLSELECTED()) does work from the video.
Counting consecutive days with sales - Unplugged #47 (youtube.com)
User | Count |
---|---|
109 | |
82 | |
74 | |
53 | |
49 |
User | Count |
---|---|
133 | |
97 | |
94 | |
71 | |
70 |