Last value by date, category using date slicer

[jyaul786]

Dear Helper,

I have two tables , data table,Calendar and related each others.Data table like:

i want to get two measures(Measure start and Measure End). and output will be: on selected date or last value by Order_date from each Sub category where Category=7 and using date slicer.

For example: if i select date ranges like:

how can i achieve this using Dax ?

[jyaul786]

@Ahmedx @amitchandak @sayaliredij 

Could you please help , for above issue.

[sayaliredij]

Hi @jyaul786 

Can you elaborate more how exactly you need measures?

I was not able to understand how these highlighted values are calculated.

as 0 does nor exists at all and 15 is value from 29 Dec which is out of range. 

Thanks,

Sayali

[jyaul786]

if there is no value on date selected or before then 0 .

and for the C, there is no any value on date 30/12/2023 so output will have last value i.e. 15.

Summary , if there are no value on selected date then measure will be last(back) value by date for each sub category.