Forum Discussion
Solved
ProductX returning unexpected results when iterating over date.
I have created two PBIX file, everything is the same, except for the date dimention is useding a string, 1-8, instead of a date. With that being the only change, I am getting getting different re...
get rid of the Auto Date/Time hierarchy.
lbendlin
Super User
Super UserI did some mild refactoring. You will want to avoid nested measures if you can, and fancy filter constructs.
I seem to recall that the Italians have already written about your scenario. Something about a covering column that needs to be included in the filter context.
Thanks for that, time go back to reading the fundementals....
- lbendlin