Create measure in matrix view

[Chris1300]

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?

[serpiva64 · Accepted 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 !

[Chris1300]

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?

[serpiva64]

Hi,

wrap it with VALUE

VALUE(FORMAT(TODAY()-min('Table (2)'[Column3])-1,"fixed") )