Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Parameter Logic

Hi there,   Could somebody please help me with some logic? Below are the IF statements I need for Power BI from Excel, but New End Date and New Start Date are column fields, and with  parameters o...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    This need to be formatted so the calculation will be something similar to this:

     

    0.0903 * 24  = 2.1673

    (2.1673 - 2 ) * 60 = 10

    2: 10

     

    Basically is making the calculation in hours and picking only the integer, then multiply the decimals by 60 minutes and so on.

     

    I have the formula and can give you but need to check it on a previous file since I don't know by heart.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Okay thankyou MFelix . Could I just ask one more question regarding that?

 

The 0.0903 * 24 = 2.1672. In Power BI it automatically takes it as 2.2. Is there a function or way to make it 2.10 as 2.2 is incorrect in time terms.

 

Thanks

 

Liam

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

This need to be formatted so the calculation will be something similar to this:

 

0.0903 * 24  = 2.1673

(2.1673 - 2 ) * 60 = 10

2: 10

 

Basically is making the calculation in hours and picking only the integer, then multiply the decimals by 60 minutes and so on.

 

I have the formula and can give you but need to check it on a previous file since I don't know by heart.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Okay thankyou 🙂 that would be great  MFelix 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    MFelix 

     

    Ive managed to get a copy of the July version and view the PBIX. 

     

    That is perfect! Its just a case of the forumula to convert accurately to hours and minutes

     

    Thankypu