Forum

Calculate Same Peri...
 
Notifications
Clear all

Calculate Same Period Last Week and % Change

18 Posts
2 Users
0 Reactions
311 Views
(@dani104)
Posts: 50
Trusted Member
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?

Time-Diff.PNG

 
Posted : 21/07/2024 11:46 pm
(@mynda)
Posts: 4761
Member Admin
 

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
(@dani104)
Posts: 50
Trusted Member
Topic starter
 

Thank-you, Mynda.  🙂

 
Posted : 25/07/2024 2:45 am
Page 2 / 2
Share: