Forum Discussion
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 ...
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.
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
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."
