Calculated column Into measure

[Ariannabertoni]

I need to transform this calculated column into a measure
CALCULATE(SUM(Table1[Totaltime]) - SUM(Table1[Totaltime2]), Table1[[Weight] <> "5", Table1[[Weight] <> "6")

 

[arunsjain]

Try

CALCULATE(SUM(Table1[Totaltime]) - SUM(Table1[Totaltime2]), Table1[[Weight] <> "5" && Table1[[Weight] <> "6")

 

[arunsjain]

Hi,

Two ways

First
In power query, you can add one column like time difference "Duration" and apply the following measure

= Calculate (Sum(Table1[Duration]), Table1[[Weight] <> "5"&& Table1[[Weight] <> "6")

Second
= CALCULATE(SUM(Table1[Totaltime]) - SUM(Table1[Totaltime2]), Table1[[Weight] <> "5" && Table1[[Weight] <> "6")
Change format of measure to (h:nn)

Hope it will help.

 

[arunsjain]

Hi, minor correction in above post (number 5 and 6 should not be in " ")

Hi,

Two ways

First
In power query, you can add one column like time difference "Duration" and apply the following measure

= Calculate (Sum(Table1[Duration]), Table1[[Weight] <> 5 && Table1[[Weight] <> 6)

Second
= CALCULATE(SUM(Table1[Totaltime]) - SUM(Table1[Totaltime2]), Table1[[Weight] <> 5 && Table1[[Weight] <> 6)
Change format of measure to (h:nn)

Hope it will help.