AR Aging Problem With Calculated Columns

[Anonymous]

Good day everyone, 

this is frustrating to me as I am relatevely new to power bi and i am really in a hurry... Sorry if this has been posted before. 

I have aging of AR which i would like to present with more granularity. as an example i would like to add 1-7 aging bucket based on the days late column. 1-7 = if(and(days late >=1,days late<=7),open balance,"") - basically this is how it works for me in excel. the deal is power bi tells me my columns are not the same format. i changed them and made sure they are (please refer to the screenshots). Can anyone help me please to make this segregation?

[sanimesa · Accepted solution]

Please try replacing the "" in your formula with BLANK() and see if it solves the issue. 

[Anonymous]

@Ashish_Mathur ,

@sanimesa 

Thank you! You are amazing! And Saved my life!!!

Deeply appreciated!

Atanas

[Ashish_Mathur]

You are welcome.  Thank you for your kind words.

[Ashish_Mathur · Accepted solution]

Hi,

Write the calculated column formula exactly the way you would have written it in Excel i.e. =IF(AND()....  Just replace the "" with BLANK().

Hope this helps.

[sanimesa · Accepted solution]

Please try replacing the "" in your formula with BLANK() and see if it solves the issue.