Forum Discussion

jyaul786's avatar
jyaul786
Helper II
2 years ago

Last value by date, category using date slicer

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 ?

 

 

 

Need Help

3 Replies

  • sayaliredij's avatar
    sayaliredij
    Solution Sage
    2 years ago

    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's avatar
      jyaul786
      Helper II
      2 years ago

      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.