none
Round decimal number to whole number in power query RRS feed

  • Question

  • Dear All,

    I want to write the query to get the whole unit column as per below table is calculated whole unit column in Excel

    I want to do it in power query.

    Thanks and regards,

    Heng

    Room Unit Month Year AccSum RunningTotal       Rnd2      Whole       Unit
    Room1 25 31 365 2.123288 2 0 2
    Room1 25 28 365 1.917808 4 2 2
    Room1 25 31 365 2.123288 6 4 2
    Room1 25 30 365 2.054795 8 6 2
    Room1 25 31 365 2.123288 10 8 2
    Room1 25 30 365 2.054795 12 10 2
    Room1 25 31 365 2.123288 15 12 3
    Room1 25 31 365 2.123288 17 15 2
    Room1 25 30 365 2.054795 19 17 2
    Room1 25 31 365 2.123288 21 19 2
    Room1 25 30 365 2.054795 23 21 2
    Room1 25 31 365 2.123288 25 23 2
    Room2 27 31 366 2.286885 2 0 2
    Room2 27 29 366 2.139344 4 2 2
    Room2 27 31 366 2.286885 7 4 3
    Room2 27 30 366 2.213115 9 7 2
    Room2 27 31 366 2.286885 11 9 2
    Room2 27 30 366 2.213115 13 11 2
    Room2 27 31 366 2.286885 16 13 3
    Room2 27 31 366 2.286885 18 16 2
    Room2 27 30 366 2.213115 20 18 2
    Room2 27 31 366 2.286885 22 20 2
    Room2 27 30 366 2.213115 25 22 3
    Room2 27 31 366 2.286885 27 25 2

    Tuesday, January 1, 2019 12:34 PM

Answers