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.

LorenzoTr's avatar
LorenzoTr
Frequent Visitor
2 years ago

Thanks, Diff1 is working well!

About diff1, I tried to enter it as a measure but I find some issues with formulas (HOUR, MINUTE, SECONDS, EARLIER) cause it's not possible to enter column (ex: 

HOUR('Table'[Timestamp_Convert]

Do you've any suggestion?

Anonymous's avatar
Anonymous
Not applicable
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.