Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all, I want to calculate the number of days between each stage of an application.
Earliest FirstDate column shows the first date that the application went into each category. The categories listed above have subcategories, that's why there are more than one date for each category. I want to calculate the number of days between the first date of each category. You will seen a summary for Case ID showing first dates for each category.
For example I want to show:
Post AIP- Pre App days as Apps in Preparation - Post AIP- Pre App
Apps in Preparation days as Apps With Credit - Apps in Preparation
Apps With Credit days as Drawdowns - Apps With Credit
Drawdowns as total of all category days or Drawdowns - Apps in Preparation.
Thanks all
Can anyone help out with this issue please? It looks like an easy fix for a Power BI expert.
Thank you.
Really appreciate if anyone could help me on this issue. Thanks a mil
How can I include 'Sort Order' in the formula above as it's a column in a table called 'Stage Order'. See below source tables for each column.
Table | Column |
Status Activity | Case ID |
Status Activity | Stage |
Stage Order | Sort Order |
Status Activity | Status Date |
Status Activity | Earliest FirstDate |
You can Create a new column to get the Data like this
and the code used to create the Column is
@smithub , Based On what I got
Measure for time between Stage
measure =
Var _date = Minx(filter(allselected(Table), [Case ID] = Max([Case ID]) && [Sort Order] = Max([Sort Order]) ), [Status Date])
Var _last = Maxx(filter(allselected(Table), [Case ID] = Max([Case ID]) && [Sort Order] < Max([Sort Order]) ), [Sort Order])
Var _lastDate = Maxx(filter(allselected(Table), [Case ID] = Max([Case ID]) && [Sort Order] =_last ), [Status Date])
return
datediff(_lastDate ,_date , day)
My sort order column is coming from a different source table called 'Stage Order'. I'm new to Power BI. How can I include Sort Order in the formula?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |