Get the last available value when data are not filled

[Anonymous]

Hi, 

I am looking to display KPI Values per Business Unit on a bar graph. The datas are filtered by Year and Quarter thanks to a slicer. 
KPI Values are fielded every 1st day of the month. My date column in my date table is only 1st day of the month-year. So far no problem. 

However, the KPI value may not be fielded every month and would need to get the last available value as the current value. This should be done per KPI Name, per Business Unit. 

I have been searching with the LastNonblank function but haven't managed to make it work. Would you have any ideas ?

My data model is like this : 

Completed KPI (Fact Table)	KPI	Date	Business Unit
id Date id  KPI id  Business Unit id  KPI Value	id  KPI Name	id  01-Month-Year Year Quarter-Year	id  Business Unit Name

Thanks for your help

[Anonymous · Accepted solution]

Please find the full solution here:

https://1drv.ms/u/s!ApyQEauTSLtOgYM860amMhsH96XDzw?e=tIiKi1

Best
D

[Anonymous]

I had to do some modification with the DAX but based on what you did I managed to make it works. 
Thanks !!