Forum Discussion
Helper IUpdate table and last record by category
Hi Mi_80
Firstly, make sure you have the relationship correctly linked between your Date table and fact table which should be Date[Date] and Table[Created On]. From here, you can try something like the following measure:
Users (Approved) = VAR _category = "approved" Var _1 = CALCULATE ( DISTINCTCOUNT ( Table[User name] ) , FILTER ( ALL ( 'Table' ), Table[Category 1] = _category && Table[Created on] <= MAX ( 'Date'[Date] ) ) ) RETURN _1Make sure to update your Table and Column names. Also, if you want to change the category, just create a new measure and update the _category from "approved" to whatever the other category is you're wanting.
Hope this helps mate.
Theo
Community ChampionHi Mi_80
Firstly, make sure you have the relationship correctly linked between your Date table and fact table which should be Date[Date] and Table[Created On]. From here, you can try something like the following measure:
Users (Approved) =
VAR _category = "approved"
Var _1 =
CALCULATE (
DISTINCTCOUNT ( Table[User name] ) ,
FILTER ( ALL ( 'Table' ),
Table[Category 1] = _category && Table[Created on] <= MAX ( 'Date'[Date] ) )
)
RETURN
_1
Make sure to update your Table and Column names. Also, if you want to change the category, just create a new measure and update the _category from "approved" to whatever the other category is you're wanting.
Hope this helps mate.
Theo
Helper IYou're a star. That works fab thank you🤗