Forum Discussion
Solved
Using historical dates to calculate system status at intervals in the past
Hi, I have three main entities: Sites (different websites), that each have many Pages, that each have many Reviews - i.e. records of when they were reviewed in the past. I'm wanting to count the num...
"Perhaps the dates used to created the matrix columns need to be related to the other tables used in the DAX formula?"
Exactly. If you see the same number over and over you know you picked the wrong field, from a dangling table or from the wrong end of a search direction.
lbendlin
Super User
Super User"Perhaps the dates used to created the matrix columns need to be related to the other tables used in the DAX formula?"
Exactly. If you see the same number over and over you know you picked the wrong field, from a dangling table or from the wrong end of a search direction.
Thanks for that. I'll mark the combination of your comments as the solution. I've added details of the evental way I solved this. Any comments on that welcome.
