Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi,
is this what you need?
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?
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") )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |