Forum Discussion
Subtotal for measure calculating changes over time using date slicer
Hi everyone, I'm currently using a data set that takes a daily snapshot of my data and appends it to the table. An example of my data is this (create date is the daily snapshot date): ...
Hi brittney,
From your formula:
First Date = CALCULATE(MIN('date table[First Date]), ALLSELECTED ('date table'))
I could not get any data about 'date table', could you please offer me more information about it so I could have a test?
Regards,
Daniel He
v-danhe-msft The date table is a table with a single date column built from the distinct "create dates" from the Qty Archive table. The Create Dates are every date the Qty Archive table appends another day of data.