Forum Discussion
Measure to Count by Last Stage
I am trying to write a pair of measures but I'm stuck. I'm working with a table that gives the history of clients through a series of processing stages. Each row represents a stage movement event, gi...
Heh, I always feel like I'm cheating when I do things in columns instead of measures. Yep, that method works. Thank you.
greggyb
Resident Rockstar
Resident RockstarColumns: Anything that user filters / interaction with reports cannot change.
Measures: Anything that user interaction can change.
More specifically, my usual argument is that if it's known at refresh-time and unchanging in the face of filters / interaction, it should be a part of ETL, not done in the model. This sort of column logic is actually much easier to do in DAX than in Power Query, and I don't know what your ultimate source is. I'd always recommend pushing changes / transformations / new columns as far up the source chain as possible, but if this has to be done in DAX, it's not so bad.