Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
My calulation below is showing values True or False:
Missing Invoices From Sales By GL = CALCULATE( COUNTROWS('Sales Invoices by GL Account'), FILTER( 'Sales Invoices by GL Account', 'Sales Invoices by GL Account'[Invoice Number] = EARLIER('VAT Report - VAT Return'[Invoice Number]) ) ) > 0
I want to show 'Matched' if the invoice is found in both reports and 'Missing' if not found, however it just shows Ture and False in my results. I am not sure how to change the values.
Thank you in advance
Solved! Go to Solution.
Or this, without the variable:
Missing Invoices From Sales By GL = IF ( CALCULATE ( COUNTROWS ( 'Sales Invoices by GL Account' ), FILTER ( 'Sales Invoices by GL Account', 'Sales Invoices by GL Account'[Invoice Number] = EARLIER ( 'VAT Report - VAT Return'[Invoice Number] ) ) ) > 0, "Matching", "Missing" )
Thank you, that was the solution I was looking for.
Hi @craig811
Are the TRUE and FALSE that you get now correct already, I mean, would you just want to have ' Matched' in place of TRUE and 'Missing' in place of FALSE?
Thank you for the reply.
Yes, the Ture and False values are correct. However, I just want to rename them 'Matched' for True and Missing' for False, within my above formula.
Thank you
Ok, then try this, which reuses your code:
Missing Invoices From Sales By GL = VAR _Result = CALCULATE ( COUNTROWS ( 'Sales Invoices by GL Account' ), FILTER ( 'Sales Invoices by GL Account', 'Sales Invoices by GL Account'[Invoice Number] = EARLIER ( 'VAT Report - VAT Return'[Invoice Number] ) ) ) > 0 RETURN IF ( _Result, "Matched", "Missing" )
Or this, without the variable:
Missing Invoices From Sales By GL = IF ( CALCULATE ( COUNTROWS ( 'Sales Invoices by GL Account' ), FILTER ( 'Sales Invoices by GL Account', 'Sales Invoices by GL Account'[Invoice Number] = EARLIER ( 'VAT Report - VAT Return'[Invoice Number] ) ) ) > 0, "Matching", "Missing" )
Thank you, that was the solution I was looking for.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |