Make a row as column and apply it as filter

[Anonymous]

Hi , I am trying to create a report where I have the row as the Month of multiple columns. After every 3 rows I have the Month row added. How to make the Month row as column and use it as filter. Sorry I am new to Power BI so asking this basic question

This is how it looks in Power BI

[ibarrau · Accepted solution]

Hi. The best way of building a data strategy is not always to create an amazing ETL or process that transform any data. In this case I would suggest changing the way the data is stored. It will be a difficult to turn that excel into something useful. It might be easier change the way it is now and so that won't be a problem in the future.

You can create a new table with four columns (that would be like a dimension of measures):

date or period | account type | kpi | value

 You can also build it this way:

date or period | account type | PreviousMonth | Current Month | % Change

 Consider that if previous and change are just formulas, you could just get current month and calculate the rest on PowerBi DAX measures.

If you just want to transform data without changing anything, you might want to split the table by Active Accounts values and another table by Active Address values, filter your result by Month and Current month, fill up values to replace the null of the month for the current month value, and finally filter by only month to keep your data like "Month 1 | 289".

At the end you can create a hardcoded third table with "Active account" text or "active address" to keep it as identifier so you can append both tables together.

The thing that you MUST change of your data is "Month 1", try using something usefull like "202201"

I hope that make sense

[lbendlin]

Please provide sanitized sample data in a usable format.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

If you find that you can achieve your requirements better in Excel then you can also consider continuing to use Excel.  Power BI is not good at exotic table formats.