Forum Discussion
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 sel...
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
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.