How to modify expression return Feb 2021 Amount ?

V-lianl-msft 

Thank you for sharing.

The reasons i need it with out using filter panel is because , i need it dynamic change every month with me change the filter panel setting. 

Paul

Hi admin11 ,

Do you want to display the sum of the most recent months in the fact table with a card?

Try this measure:

Measure = var min_ = CALCULATE(MAX(GL[Posting Date]),ALLSELECTED('Date'))
var ym = FORMAT(min_,"YYYY-MM")
return CALCULATE(GL[AMOUNT],FILTER(GL,GL[1_EXP]="EXP"),FILTER('Date','Date'[YrMth Sort]=ym))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft 

Thank you very much for your sharing. it work fine on the simple file , But when i try to test with my raw data , i notice that it does not work. it display blank , Hope you can take a look.

https://www.dropbox.com/s/9c0c1n12y12vbfp/PBT_V2021_381%20Sample%20Data%20ONLY%20ID%20GL%20get%20feb%20expense_.pbix?dl=0

Above is my PBI file 

Paul