How to create a Flag to filter those over due more then 100 days ?

[admin11]

Hi All

@Ashish_Mathur help me a lot for solve my issue :-

https://community.powerbi.com/t5/Desktop/How-to-compute-due-date-base-on-invoice-date-and-Credit-ter...

Now i got one more requirement , only filter over due more then 100 days , See the image below  :-

Seek help to modify the below expression :-

Due = today()-(AR_S[AR Invoice Date]+AR_S[TERM])+1

I have try to add 100 to above expression , it does not work. 

My PBI file :-

https://www.dropbox.com/s/i0tsqun6e58cfmd/AR%20ADL%20V007.pbix?dl=0

Paul

[Ashish_Mathur · Accepted solution]

Hi,

In the "_Flag_Due > 1 Day" calculated column formula, I simply changed >1 to >100.  This is the result i got

[Ashish_Mathur · Accepted solution]

Hi,

In the "_Flag_Due > 1 Day" calculated column formula, I simply changed >1 to >100.  This is the result i got

[admin11]

@Ashish_Mathur 

Thank you very much for your help , it work fine. 

How about can i filter only 152 to 181 ? How to modify the code ?

_Flag_Due 152 to 181 = if(AR_S[Due]>152&&AR_S[Due]<181 ,1,0)

I have try above it look like not correct .

Paul

[Ashish_Mathur · Accepted solution]

You are welcome.  Please read up on the AND() function and doit yourself.

[admin11]

@Ashish_Mathur @Yes , thank you sir . I will do the read up .