Solved: Re: Transforming Data

Anonymous · ‎04-28-2020

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?

parry2k · ‎04-28-2020

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

v-juanli-msft · ‎04-28-2020

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 · ‎04-28-2020

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.