Forum Discussion
DAX Measure Error when a column is blank empty data points
Hi Experts i am trying to sum where the following columns are blank only and either True or false - my conditions are: 1. So PostingDate = blank 2. InvoiceChecked = true (text) 3. InvoiceNumbe...
Anonymous It is giving me this result
Here is some sample data.... not working
| CreatedOn | SOOrderValue | SOPostingDate | InvoiceChecked | InvoiceNumber |
| 20-Jan-22 | £326.04 | True | ||
| 18-Jan-22 | £2,780.8 | True | ||
| 19-Jan-22 | £1,346.85 | True | ||
| 19-Jan-22 | £119.02 | True | ||
| 20-Jan-22 | £570.23 | True | ||
| 18-Jan-22 | £1,159.81 | True |
Anonymous It is giving me this result