Count Customers aggregately based on their latest status change on a monthly basis
Hi guys, i have this table of customers (Contact Id) with all their status changes along their way on a monthly basis: i wish to calculate by measures the number of customers for each status for each month, which means the latest status available should be considered and calculated until next status change. once a customer has its first change, he should be calculated until current month. There is a table to present what i mean (but in columns. not measures): thanks in advance, Amit
Count values over a period
Hi team, I have a fact table which contains Student's details like below (attached sample copy), I'm trying to create a DAX expression that will enable me to return data when a student failed/passed status is in between a selected date range. For example consider HARRY Data from below table When i select a date range of 01/01/19 to 31/05/21 using a date slicer, He should be treated as failed student and his count should be in Failed count, If i move slicer to 06/01/21 His count should be removed from Failed count and should be added in Passed student as he passed the exam on 06/01/21. Please let me know if needed more information.
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!
