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,
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.
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |