Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I'm trying to create a PowerBI report using Azure DevOps (Analytics View) WorkItems Backlog. I have a calender table with default Date Column (Date/Time datatype) and Main table with Created Date , Closed Date . Based on some help from this community posts, I have created few measures which seems to be working except Cumulative running total . appreciate if anyone guide me what I'm missing here.
Main Table Name >> Dashboard
Columns used from Main Table >> Created Date, Closed Dated, Work Item Id
Date table
Hi @Anonymous ,
Hi, @Anonymous
Please try something like below.
ADOBacklog =
CALCULATE (
SUMX ( VALUES ( datetablemonthcolumn ), [ADOBalance] ),
FILTER ( ALL ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks. I tried and it didnt work yet. Hope you can see my reply (with more details) in this thread. It sill gives the difference between Created Count vs Closed Count
@Anonymous , refer to my blog, create a formula same as current employee and try
hi @amitchauhan
I think I referred your post from the forum earlier. Anyway, With the CurrentEmployers example I followed and it seems to be return the balance not the cumulative total yet. Not sure I'm doing something wrong with the way I define the date etc... I have my X Axis in the chart / Date column in matrix is based on formated "Created Date" which is
Here is my various try of calculating cumulative measure including your your suggestion (last one) from your example which I downloaded the PBIX
ADOO =
CALCULATE(
COUNTx(
FILTER(
Dashboard, Dashboard[Created Date] <= MAX(DateTable[Date]) &&
(ISBLANK(Dashboard[Closed Date]) ||
Dashboard[Closed Date] > MAX(DateTable[Date]))
),
(Dashboard[Work Item Id])
),
CROSSFILTER
(
Dashboard[Created Date],DateTable[Date],None
)
)
Can you let me know if I'm missing anything
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |