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!
I have a report which has daily orders and billings. I want to add a column for backlog (any orders that are still open) However, when I try to add it, it just gives me the daily amount, but i would like backlog to be a summation total and not a daily value like the other columns.
Example below: I want a column like in blue, where it gives me the total backlog for each day, and not the daily amount.
Any tips?
Thanks!!
Solved! Go to Solution.
Hi @PBINewbie920 ,
Calculate column expression:
Backlog =
var _2021totalbacklog = 500
return
SUMX(FILTER('Backlog',[Backlog]<=EARLIER('Table'[Date])),[Daily Added])+_2021totalbacklog
Measure in visual :
backlog_m =
VAR _2021totalbacklog = 500
RETURN
SUMX (
FILTER ( ALLSELECTED ( 'Backlog' ), [Backlog] <= MAX ( 'Table'[Date] ) ),
[Daily Added]
) + _2021totalbacklog
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PBINewbie920 ,
Calculate column expression:
Backlog =
var _2021totalbacklog = 500
return
SUMX(FILTER('Backlog',[Backlog]<=EARLIER('Table'[Date])),[Daily Added])+_2021totalbacklog
Measure in visual :
backlog_m =
VAR _2021totalbacklog = 500
RETURN
SUMX (
FILTER ( ALLSELECTED ( 'Backlog' ), [Backlog] <= MAX ( 'Table'[Date] ) ),
[Daily Added]
) + _2021totalbacklog
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@PBINewbie920 , These tables need to share the common date and other dimension tables.
Then you can show this visual using common date table
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |