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 ,

 

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.