Transforming Data

[Anonymous]

Hi All, I would like to figure out how to share my pbix file that is quite large (71mg) and has confidential data for some help transforming the data? I am not sure how to "mask" my data so that it remains confidential. I would share the file with a particular person who is looking to help but don't want it out there for everyone to see.

My data has column measures that also have the timeframe in the measure name like Sales4, Sales13, Sales26, Sales52, etc with many more measures and all measures having 4,13,26 or 52 at the end of the name.

I want to get the time frame number removed from the column names so that I have 1 sales colum, 1 time frame dimension column and 4 rows of data for sales 4 week, 13 week....

Any initial thoughts please?

[v-juanli-msft]

Hi @Anonymous 

Assume you want this:

If so,please open "transform data" in Power BI, then do as below:

Besides, please don't share any real data with anyone for secuirty.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@Anonymous my email is in my signature and feel free to share via email.