Same formula, different results for some months

[lc1]

Hello,

Please see below, when dividing PAR_HOURS by FT-CE Sched Hr the correct result should be around 20%.

Why does the formula work for some months and not others? (See Feb and April)

Thanks

PPE_DT	PAR_HOURS	FT-CE	FT-CE Sched Hr	PAR_HOURS divided by FT-CE Sched Hr
2/9/2019 0:00	8951	475	38000	12%
2/23/2019 0:00	8003	475	38000	11%
3/9/2019 0:00	8051	472	37760	21%
3/23/2019 0:00	8119	486	38880	21%
4/6/2019 0:00	8407	485	38800	11%
4/20/2019 0:00	8126	485	38800	10%
5/4/2019 0:00	8311	483	38640	22%
5/18/2019 0:00	7340	482	38560	19%
6/1/2019 0:00	6677	480	38400	17%

[TeigeGao]

Hi @lc1 ,

Please create a calculated column with the following DAX query:

PAR_HOURS divided by FT-CE Sched Hr = DIVIDE(Table1[PAR_HOURS],Table1[FT-CE Sched Hr])

The result will like below: 

We can also create a measure like below:

PAR_HOURS divided by FT-CE Sched Hr 2 = DIVIDE(MIN(Table1[PAR_HOURS]),MIN(Table1[FT-CE Sched Hr]))

The result will like below:

Best Regards,

Teige

[lc1]

Neither of the options worked.

My original formula giving me the wrong results in Feb and April was:

DIVIDE(

    SUM('Absenteeism'[PAR_HOURS]),

    SUM('Bus Oper-Filled Full Time'[FT-CE Sched Hr])

)

When I used the one below, it can't find the second table (two different tables)

PAR_HOURS divided by FT-CE Sched Hr = DIVIDE(Table1[PAR_HOURS],Table1[FT-CE Sched Hr])

And lastly when I used the second option recommend, the result is all 0%

PAR_HOURS divided by FT-CE Sched Hr 2 = DIVIDE(MIN(Table1[PAR_HOURS]),MIN(Table1[FT-CE Sched Hr]))

[Anonymous]

The formula

NEW PERCENTAGE = Table2[PAR_HOURS] / Table2[FT-CE Sched Hr]

worked fine for me...

May be a formatting issue with your source data or in the query. Make sure the PAR_Hours and FT-CE Sched Hr are set to Whole Number.

@lc1 

[lc1]

I can't use that formula because the values are coming from different tables/sources. The hours are coming from a database where I have to sum all daily par hours per employees, per garage to get the total you see in the example below and the Scheduled hours are coming from an excel table.

What I find weird is that it works for some months and not for the others...

[Anonymous]

I am confused. Why can't you use that formula? Is your screenshot not what your data looks like in PBI?

[lc1]

The screenshot is based on the original formula:

PAR_HOURS divided by FT-CE Sched Hr =

DIVIDE(

    SUM('Absenteeism'[PAR_HOURS]),

    SUM('Bus Oper-Filled Full Time'[FT-CE Sched Hr]))

Which works for all months except Feb and April. I looked at the data and all values/format seem to be consist when compared one month to the other.

[Anonymous]

Can you post the formula you are using?

Did you make many edits in the query editor that effected either of these columns*?

[lc1]

Original formula:

PAR_HOURS divided by FT-CE Sched Hr =

DIVIDE(

    SUM('Absenteeism'[PAR_HOURS]),

    SUM('Bus Oper-Filled Full Time'[FT-CE Sched Hr])

)

And no changes were made in the query editor.