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.

Anonymous's avatar
Anonymous
Not applicable
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.