Sum of last non blank value between two dates

[Aza33ello]

Hello!

I have some troubles with dax measure and would appreciate any help.

Screenshot below shows example data, I want to make dax measure that can sum the last non-blank value for previous 6 month before Jan 2022, should be 2,00 here:

4,00 for that:

and nothing for this:

For instance, normally If my current date filter is Jan 2023 the measure will show me sum of Jan 2022 but if Jan 2022 is empty the measure should find the last value close to Jan 2022 within 6 months and sum (Nov 2021 on Pic#1, Sep 2021 on Pic#2 and nothing on Pic#3) 

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

I hope the below sample can provide some ideas on how to create a solution for your datamodel.