Forum Discussion
Solved
Create measure in matrix view
Hello, See attached screenshot. I have a simple matrix table with [userID] and [EARLIEST login date] and [LATEST login date]. I would like to create a new measure that shows # of days since activ...
Hi,
is this what you need?
Measure = if (ISINSCOPE('Table (2)'[Column2]),FORMAT(TODAY()-min('Table (2)'[Column3])-1,"fixed"))If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi,
is this what you need?
Measure = if (ISINSCOPE('Table (2)'[Column2]),FORMAT(TODAY()-min('Table (2)'[Column3])-1,"fixed"))
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Is there a way to format this new column to a "Whole Number"? I changed "fixed" to "#,0" which gave me integer number but i cant sort the new column because its still is formatted as a TEXT. How can i change this?
Hi,
wrap it with VALUE
VALUE(FORMAT(TODAY()-min('Table (2)'[Column3])-1,"fixed") )
