Forum Discussion
Distinct count of ID based on Latest Status
Hello everyone, I am new to Power BI and need some help. I have Order ID, Order status and Time modified(Time when the Order status was changed) as columns. My data looks like this: Ord...
Hi,
PBI file attached.
Only one calculated column is needed with WINDOW function; but it requires profound comprehension of DAX.
amitchandak
Super User
Super UserAnonymous , Create measures like
M1 =
VAR MaxTime = CALCULATE(
MAX('Table'[Time modified]),
ALLEXCEPT('Table', 'Table'[Order ID], 'Table'[Date Only])
)
RETURN
IF('Table'[Time modified] = MaxTime, TRUE(), FALSE())
Order Count =
SUMX(
VALUES('Table'[Date Only]),
CALCULATE(
DISTINCTCOUNT('Table'[Order ID]),
[M1] = TRUE()
)
)
Latest Date
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0