Concatenate multiple columns together in the summarized table

[Anonymous]

Hello,

I am working on something in powerbi and i want to concatenate all the month measures in the one single column.

This is how i am currently getting but i want to have 1 single column with all the numbers. 

The July_TO, August_TO and September_TO are the calculated measures in the Actives table.

I am a little puzzled over this and  any help will me mu
 

[amitchandak]

@Anonymous , Try like

Summarize(
union(
Selectcolumns(Active, "Date", Active[date], "fiscal Year", Active[fiscal Year],"Month", "Jul" , "Value", [July_to]),
Selectcolumns(Active, "Date", Active[date], "fiscal Year", Active[fiscal Year],"Month", "Aug" , "Value", [August_to]),
Selectcolumns(Active, "Date", Active[date], "fiscal Year", Active[fiscal Year],"Month", "Sep" , "Value", [september_to])
), [Date],[fiscal Year],[Month],[Value])

refer: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Better you would have done unpivot data, if possible.

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

Thank you for this. I will try this out.