Converting Tableau Calculation to Power BI

[Anonymous]

Hi

I have this column in a tableau dashboard that I built and I was wondering how I convert the data in the same way. I am trying it through the custom column in Power Bi. My calculation in Tableau was

STR(INT(SUM([Total Display Time])/86400))

+ " Days, " +

IF (INT(SUM([Total Display Time])%86400/3600))

< 10 THEN "0" ELSE "" END + STR(INT(SUM([Total Display Time])%86400/3600))

+ " Hours, " +

IF INT(SUM([Total Display Time])%3600/60)

< 10 THEN "0" ELSE "" END + STR(INT(SUM([Total Display Time])%3600/60))

+ " Minutes, " +

IF INT(SUM([Total Display Time]) %3600 %60)

< 10 THEN "0" ELSE "" END + STR(INT(SUM([Total Display Time]) %3600 %60))

+ " Seconds "

Could someone possibly help me convert this to a Power BI to end with the same results?

TIA

[V-pazhen-msft · Accepted solution]

@Anonymous 

Try create this using dax with calculate column:

CONCATENATE(SUM([Total Display Time])/86400,
CONCATENATE("Days"
CONCATENATE(IF(SUM([Total Display Time])/86400/3600<10,"0",""),
CONCATENATE("Hours",
CONCATENATE(IF(SUM([Total Display Time])/3600/60<10,"0",""),
CONCATENATE("Minutes",
CONCATENATE(IF(SUM([Total Display Time])/3600/60<10,"0",""),
CONCATENATE(SUM([Total Display Time]) /3600/60), "Seconds"))))))))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , In power query

Duration(Number.IntegerDivide(Number.FromText([Cycle:duration]),86400) ,Number.IntegerDivide(Number.Mod(Number.FromText([Cycle:duration]),86400),3600),
Number.IntegerDivide(Number.Mod(Number.Mod(Number.FromText([Cycle:duration]),86400),3600),60),
Number.Mod(Number.Mod(Number.Mod(Number.FromText([Cycle:duration]),86400),3600),60)
)

DAX  - Measure or column both will work
Quotient([Total Display Time],86400) & ":" Quotient(mod([Total Display Time],86400),3600) &":" & Quotient(mod(mod([Total Display Time],86400),3600),60) &":" & mod(mod(mod([Total Display Time],86400),3600),60)

[Anonymous]

Unfortunately this didn't work in my custom column am I doing something wrong?

Thanks