Forum Discussion

LorenzoTr's avatar
LorenzoTr
Frequent Visitor
2 years ago
Solved

Difference between values in a day and incremental column

Hi All, I would calculate the difference between values in a day and relative column that shows that increment of the day (values at 12AM should be 0). Here the tab with columns "Diff" and "Increm"...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi LorenzoTr ,

    You want to make sure that your date column is in the correct time format, such as "YYYY-MM-DD HH:MM:SS .

    My diff's DAX has the EARLIER function, which is used in the calculated column, so be careful to recognize it.

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Tom Shen

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

LorenzoTr , Two New columns

 

Create an additional Date column in Table

Date = datevalue([Timestamp_Convert])

 

and then

 

Diff with last value =
var _min = Minx(filter(Table, [Date]= Earlier([Date])), [Timestamp_Convert])
return
Minx(filter(Table, [Date]= Earlier([Date]) && [Timestamp_Convert] = _min), [Count_H] ) - [Count_H]