Forum Discussion

morther's avatar
morther
Helper I
9 years ago
Solved

Calculation function only returning minutes

I have created a New Column called Downtime.  It is supposed to take the total Downtime Minutes and break it into Days, Hours, and Minutes.  It is pulling the remainder minutes properly but is not ad...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    Can you post some sample data of your downtime table?  The issue might be that you need to specify some type of aggregation for your downtime minutes column, rather than the raw column reference you are providing.  In my example, I just hard coded in the number 99, but if you have multiple values in your downtime minutes column, it wont work by just giving the column name.

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

I tried both yours and mine and they both work for me.  when put into a card I get "0 days 01 hours 39 mins" for your 99 minutes value.

morther's avatar
morther
Helper I
9 years ago

Thanks for the reply to my post.

 

Can you explain what you mean when you say "when put into a card"  Maybe I can try that to help me understand why this is not working.

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago

    I am referring to the Card visual:

     

    • morther's avatar
      morther
      Helper I
      9 years ago

      so strange that this is not working for me.  Do you think it might have something to do with the datatype of the source?

      • dkay84_PowerBI's avatar
        dkay84_PowerBI
        Microsoft Employee
        9 years ago

        What is the source?  Are you using DirectQuery or Import?