Forum Discussion
Complicated IF Statement
I have this for a new column
Total = IF('Credit Balance'[Azure Service Commitment]="Ending Balanace",'Credit Balance'[Value]+LOOKUPVALUE(Trueups[Applied Credits],Trueups[Date],'Credit Balance'[Date (bins)]))
This isnt failing for creating the column but the column is all blanks.
In table Credit Balance I am tryhing to find all rows in column Azure Service commitment that = Ending Balance, then in the same row add the number from the Value column to
this is where it gets confusing
In that same row I want to match the date in Date(Bins) column with Date column in the Trueups table an then add it the bold Value in the above paragraph.
Here is a smple of the Credit Balance Table
| Azure Service Commitment | Value | Date (bins) |
| Beginning Balance | $50. | 2018-09-01 |
| Purchased Credits | $10. | 2018-09-01 |
| Adjustments | $22. | 2018-09-01 |
| Utilized ( subtracted from balance) | $400. | 2018-09-01 |
| Ending Balance | $100. | 2018-09-01 |
Here is a sample ot Trueup table
| Date | Applied Credits |
| 2018-09-01 | $6000.44 |
Any ideas whe my formula produced all blank cells
What I want to have is the following result
| Azure Service Commitment | Value | Date (bins) | Total |
| Beginning Balance | $50. | 2018-09-01 | |
| Purchased Credits | $10. | 2018-09-01 | |
| Adjustments | $22. | 2018-09-01 | |
| Utilized ( subtracted from balance) | $400. | 2018-09-01 | |
| Ending Balance | $100. | 2018-09-01 | 6100.44 |