Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Staff Utilisation

Hi,   I'm trying to do something which I thought would be really simple but obviously not for me so here I am.  I have a table similar to the one below.  I am trying to work out staff %age utilisat...
Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try new table

    Staff Utilisation = SUMMARIZE('Table1';Table1[Employee No.];Table1[Period];"%utilization";divide(calculate(SUM(Table1[Units]);'Table1'[Transation Type Code]=100);calculate(SUM(Table1[Units]));0))

    do not hesitate to give a kudo to useful posts and mark solutions as solution

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Az38,

 

I'm getting an error DAX comparison operations do not support comparing values of type Text with values of type Interger.  Consider using the VALUE or FORMAT function to convert one of the values.

 

I've looked at my data and only the units are Number the rest are text ?

 

Thanks

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

in power query mode set all digit columns as Number types

go to the Query Editor, set mouse on column and in Transform ribbon choose Data Type Whole Number or Decimal Number (for Units column)

maybe.. you will need to replace "." to "," in Units column (it depends on your localization)

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi az38,

     

    Legend !! I found it, it was treating the Transaction Type code as a number.  I put "" around the 100 code and worked perfectly.

     

    Thanks for your help !