My expression 1-31 Day return wrong value

[admin11]

Hi All

I have a expression no error ,when it compute last 30 days out standing amount :-

_1_31 Day =

SUMX(

FILTER( AP ,

DATEDIFF(AP[AP Invoice Date], TODAY() , DAY) > 1

&&

DATEDIFF(AP[AP Invoice Date], TODAY() , DAY) <= 31

),

AP[Outstanding w/o Tax (LC)]

)

It return the wrong amount.

Hope some one can advise me where go wrong ?

below link is my PBI file :-

https://www.dropbox.com/s/3igwhkilekalow5/AP%20ADL%20V001.pbix?dl=0

Paul Yeo

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[admin11]

@Ashish_Mathur 

thank you very much it work.

[Ashish_Mathur]

You are welcome.