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 following table:
invoice id | invoice particular | invoice amount | invoice status | invoice date
i want a line graph that shows accumulated by invoice status 'Payment collected' by month on the x-axis.
like for jan its 100, for feb it becomes 200 and stops... as the status updates then it counts.
please help.
Solved! Go to Solution.
Hi, @Anonymous
Could you please tell me whether your problem has been solved?
If yes, please accept the helpful answer as solution to close this thread.
You can also try formula as below:
Measure1 =
CALCULATE (
SUM ( 'Table'[invoice amount ] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[ invoice status ] ),
'Table'[invoice date] <= MAX ( 'Table'[invoice date] )
)
)
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
Could you please tell me whether your problem has been solved?
If yes, please accept the helpful answer as solution to close this thread.
You can also try formula as below:
Measure1 =
CALCULATE (
SUM ( 'Table'[invoice amount ] ),
FILTER (
ALLEXCEPT ( 'Table', 'Table'[ invoice status ] ),
'Table'[invoice date] <= MAX ( 'Table'[invoice date] )
)
)
Best Regards,
Community Support Team _ Eason
@Anonymous , Try a measure
calculate(sum(Table[Invoice Amount]), filter(allselected(Table]), [invoice date] <=max(Table[invoice date])))
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |