Update 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

_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