Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
58 | |
21 | |
18 | |
16 | |
14 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |