Reply
Regular Visitor
Posts: 26
Registered: ‎07-07-2017
Accepted Solution

Complicated IF Statement

[ Edited ]

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 CommitmentValueDate (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
 
DateApplied 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 CommitmentValueDate (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-016100.44
 

 

Accepted Solutions
Highlighted
Regular Visitor
Posts: 26
Registered: ‎07-07-2017

Re: Complicated IF Statement

Wow, cant believe that, thanks!

View solution in original post


All Replies
Super User
Posts: 1,785
Registered: ‎02-28-2017

Re: Complicated IF Statement

Looks like you spelt Balance wrong in your DAX formula.  You wrote Balana.ce


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Highlighted
Regular Visitor
Posts: 26
Registered: ‎07-07-2017

Re: Complicated IF Statement

Wow, cant believe that, thanks!