cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allan77R2V1 Regular Visitor
Regular Visitor

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 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
 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Allan77R2V1 Regular Visitor
Regular Visitor

Re: Complicated IF Statement

Wow, cant believe that, thanks!

View solution in original post

2 REPLIES 2
Ross73312 Super Contributor
Super Contributor

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
Allan77R2V1 Regular Visitor
Regular Visitor

Re: Complicated IF Statement

Wow, cant believe that, thanks!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 138 members 1,543 guests
Please welcome our newest community members: