ABS function in Power Query column or in measure

[Narender]

Hi All,

I need to use the ABS function in Power BI.

SUM(ABS(ENTERED_DATE-CLOSED_DATE)/30)

How can I achieve this in Power BI??

Thanks,

Narender

[PattemManohar]

@Narender Please try adding as "Calculated Column" as below

Diff = ABS(DATEDIFF(TestABS[EnteredDate],TestABS[ClosedDate],DAY))

Then you can have a measure to calculate SUM of Diff

Total =  SUM(TestABS[Diff])

[Narender]

Hi, 

Thanks for your feedback

It is giving me right result.

Can you please round it with 2 decimal points in same ABS formula?

Thanks

[PattemManohar · Accepted solution]

@Narender 

Diff = ROUND(ABS(DATEDIFF(TestABS[EnteredDate],TestABS[ClosedDate],DAY)),2)