Forum Discussion
Helper IICreate 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 active, which can be easily calculated by taking Today() MINUS the [EARLIEST login date]. I want this measure to be displayed as a new value in my existing matrix table.
What should the measure formula be?
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 !
3 Replies
- serpiva64
Solution Sage
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 !
Chris1300Is 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?
- serpiva64
Hi,
wrap it with VALUE
VALUE(FORMAT(TODAY()-min('Table (2)'[Column3])-1,"fixed") )