Forum Discussion
Solved
Distinct Count with value in same table
Hi everyone. Beforehand, sorry for my bad english. I have a table like this ('Table1'): CODE STATE 1015 A 1016 A 1017 B 1015 B 1016 B 1017 B 1015 C 1015 A 10...
Another thing you may want to try then is instead of appending the two data tables, merge them side by side.
So intead of your original table, you end up with something like this:
CODE PREV_STATE CUR_STATE CHANGED 1015 A A TRUE 1016 A B FALSE 1017 B B TRUE If whatever index you're using for each row stays the same between days, this may be a better way to store your data. Be sure to check my previous reply for DAX code to solve your original problem
