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

hi all

negi007 , Tahreem24 , amitchandak 

 

Thank you for your response, actually i have already tried the matrix visualization but  i have eight table to get one report.

in SQL we normally use  "Selecting column values as Field header name" like wise is there power bi is there like "Selecting column values as Field header name" because the value i mentioned before is only three values Normal, regular and special overtime.

 

and in matrix i have tried but iam not able to repeat the name or emp id for one month (30days).