Forum Discussion
Time series indexation
As long as the filter on mindate works i dont believe you need to combine the two, if theres more than 1 value per date in [Ptr %] i believe that all we need to do is change it to AVERAGE().
Measure = VAR minDate = [minDate] Return CALCULATE(AVERAGE(Table[Pct %]) ; ALL(Datatable) ; Datatable[Sales Month] = minDate)
Br,
J
Community Championhi got the file the problem is your date, your date looks like a lookup table value.
In order to identify the problem i need to replicate your pbix. If you can share the pbix that would be easier, if not please provide the dates.
It seems like the upload on wetransfer changed the column formatting. The dates in the column are correct, just the excel format needs to be changed:
Unfortunately I can't share the PBIX file as it contains sensitive information, I'm sorry!
- vanessafvg
hi, so if i understand correctly what you trying to do is fill down the value when there isn't a valid value, i can't actually see a way to do it currently but ill keep digging and if anyone else wants to jump in thats great too
Thank you very much! In fact I just want to always use the average for the first date as basis for the calculation. Unfortunately I could not find a way on how to filter the measure dynamically to the first date for the selected category/supplier/... for all rows 😞
The goal is to have a line chart where the line always starts at 100% and then the increases/decreases are displayed based on the first reference value.
- tex628
Try this:
Measure = VAR minDate = [minDate] Return CALCULATE(SELECTEDVALUE(Table[Pct %]) ; ALL(Datatable) ; Datatable[Sales Month] = minDate)Br,
J