cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I

Converter row to columns by dax in the same table

I have this in my table:

 DATE LIM FDO LIM FRP UND 26/fev 208 686 A 26/fev 939 2166 B

And I need show this like a table in my dashboard:

 DATE VALOR UND DES 26/fev 208 A LIM FDO 26/fev 939 B LIM FDO 26/fev 686 A LIM FRP 26/fev 2166 B LIM FRP

I don´t have idea how to do this in DAX, and I need make this in DAX

1 ACCEPTED SOLUTION
Community Support

Hi @caslus ,

DAX way :

``````Table 2 =
VAR a =
SELECTCOLUMNS ( 'Table', "und", 'Table'[UND], "date_", 'Table'[DATE] )
VAR k =
CROSSJOIN ( { "LIM FDO", "LIM FRP" }, a )
RETURN
k,
"result", IF (
[Value] = "LIM FDO",
CALCULATE ( SUM ( 'Table'[LIM FRP] ) ),
IF ( [Value] = "LIM FRP", CALCULATE ( SUM ( 'Table'[LIM FDO] ) ) )
)
)
``````

Pbix as attached.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
3 REPLIES 3
Community Support

Hi @caslus ,

DAX way :

``````Table 2 =
VAR a =
SELECTCOLUMNS ( 'Table', "und", 'Table'[UND], "date_", 'Table'[DATE] )
VAR k =
CROSSJOIN ( { "LIM FDO", "LIM FRP" }, a )
RETURN
k,
"result", IF (
[Value] = "LIM FDO",
CALCULATE ( SUM ( 'Table'[LIM FRP] ) ),
IF ( [Value] = "LIM FRP", CALCULATE ( SUM ( 'Table'[LIM FDO] ) ) )
)
)
``````

Pbix as attached.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Super User

I believe you want to unpivot your two middle columns, like this:

``````let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnEMcVXSUfLx9FVwc/GHsYICgKxQPxelWJ1oJSMz/bTUMqCAkYEFkDSzMAOSjqhSlsaWIAWGZiA5J6XYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"(blank)" = _t, #"(blank).1" = _t, #"(blank).2" = _t, #"(blank).3" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"(blank)", type text}, {"(blank).1", type text}, {"(blank).2", type text}, {"(blank).3", type text}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"DATE", type text}, {"LIM FDO", Int64.Type}, {"LIM FRP", Int64.Type}, {"UND", type text}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type1", {"DATE", "UND"}, "Attribute", "Value")
in
#"Unpivoted Columns"``````

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper I

This is in power query?

I need made this in DAX, becouse I have anothers columns in my table.

Announcements

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors