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 Team,
I think I am missing something obvious here - sorry for the novice question.
I have 1 job with 2 invoices. The two invoices have multiple Stockcodes on them.
The job has a Received Date and each invoice has a Invoice Created Date.
I want to know how long ON AVERAGE it takes to invoice a job.
Therefore I created a new column in the table called 'Days to Invoice' which calculates the difference between the Invoice Created Date and the Job Received Date.
This all looks good in the table.
However, when I create a CARD to give me the total Days to invoice BY INVOICE it is adding up all of the rows. Likewise the Average is the average over all the rows.
I guess I need to add something to my Measure to correct it.
Please help! 🙂
Screenshot below...
Solved! Go to Solution.
Hi @MikeyB
pleaae try
Sum =
SUMX (
SUMMARIZE (
'Table',
'Table'[Job No],
'Table'[Invoice No],
"@Days", MAX ( 'Table'[Days to Invoice] )
),
[@Days]
)
Average =
AVERAGEX (
SUMMARIZE (
'Table',
'Table'[Job No],
'Table'[Invoice No],
"@Days", MAX ( 'Table'[Days to Invoice] )
),
[@Days]
)
Hi @MikeyB
pleaae try
Sum =
SUMX (
SUMMARIZE (
'Table',
'Table'[Job No],
'Table'[Invoice No],
"@Days", MAX ( 'Table'[Days to Invoice] )
),
[@Days]
)
Average =
AVERAGEX (
SUMMARIZE (
'Table',
'Table'[Job No],
'Table'[Invoice No],
"@Days", MAX ( 'Table'[Days to Invoice] )
),
[@Days]
)
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
18 |