Forum Discussion

askspepsi's avatar
askspepsi
Helper II
6 years ago
Solved

Bring Column value as header

hi all ,  i am new to the power bi, i have a query relating to DIRECTQUERY I have a table in which the below sample data are there,     Timesheet Type OT Type OT in Mintues Manual Entry ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi askspepsi ,

     

    You may refer the formula below.

    Table 2 =
DISTINCT (
    SELECTCOLUMNS (
        'Table',
        "Regular Hour", SUMX (
            FILTER ( 'Table', 'Table'[OT Type] = "Regular Hour" ),
            'Table'[OT in Mintues]
        ),
        "normal Hour", SUMX (
            FILTER ( 'Table', 'Table'[OT Type] = "normal hour" ),
            'Table'[OT in Mintues]
        ),
        "special Hour", SUMX (
            FILTER ( 'Table', 'Table'[OT Type] = "special hour" ),
            'Table'[OT in Mintues]
        )
    )
)

     

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

askspepsi's avatar
askspepsi
Helper II
6 years ago

Anonymous 

 thank you for your efforts this is want i required, i tried it out but iam getting the below expression

  "DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi askspepsi ,

 

What's the data type of OT type column?

  • askspepsi's avatar
    askspepsi
    Helper II
    6 years ago

    OT type column data type is Decimal Numbers

    and OT in minutes data type is also Decimal Numbers.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi askspepsi ,

       

      This error means the data types on both sides of the equal sign are different so cannot be compared. Since the OT type column data type is Decimal Numbers, please try remove the quotes at the left of the equal sign.

       

      Best Regards,

      Jay

       

      Community Support Team _ Jay Wang

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • askspepsi's avatar
        askspepsi
        Helper II
        6 years ago

        hi Anonymous ,

         

        First of all i am really sorry for the delay in replying as i got stuck with work loads.

        Thank for the output which you have provided, its really provides the sum of hours as output.

         

        - Can i ask how can i get the output for employee wise and month wise.

        - The employee and months are in two different table respectively.

         

         

        regards

        askspepsi.