Measure to verify status change between dates
Hello! I'm trying to create a calcualted field to verify, if there was a Stage change between report date and previous report date based on opportunity number. Close date is not involved in this measure. Report dates are in the same column. I have tryed many different options, but till now without any success :( Data looks like this: In written words it would be so: If between report from t and t-1 was a STAGE change, then give TRUE, else FALSE. Main report is linked to second table, which defines stage order and some segmentation, and stage order can be used as a numerical value for calculated field. I do not wish to merge tables, nor pivot the main table, as it would affect other report measures and whole structure. What I would like to see in the end: Or better 1 and 0 instead of True and False. I attach a sample pbix. Thanks a lot in advance!
