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 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]
)
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |