Notifications
Clear all
Power BI
18
Posts
2
Users
0
Reactions
311
Views
Topic starter
Thank-you. Makes sense.
One (hopefully last) question on this topic please, if the difference is a negative value, is there a way to indicate such with a "-" preceding the value? Please see attached example, there is no "+" or "-", so how could this be indicated to know if the time increased or declined v. prior week?
Posted : 21/07/2024 11:46 pm
The FORMAT function can take multiple formats. The first format is for positive values and if no other formats are provided, it will apply this to all values. If two formats are provided (separated by semi-colons), the second one is for negative values e.g.
=FORMAT(your_dax_measure, "nn:ss";"-nn:ss")
Mynda
Posted : 22/07/2024 7:36 pm
Topic starter
Thank-you, Mynda. 🙂
Posted : 25/07/2024 2:45 am
Page 2 / 2
Prev