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

Hi, You may download my PBI file from here. Hope this helps.

Memorable Member

4 years ago

Solved

My expression 1-31 Day return wrong value

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

Paul Yeo