Forum Discussion
CP4L21
5 years agoNew Member
Pivot and Group Rows of Many Dates into Columns
Hi, I have rows that contain dates and I want to Pivot those rows into a colmns. However, I want those dates to be grouped when i pivot them. For example, I have sales data for a given month that is...
CP4L21
5 years agoNew Member
i cant reply because it keeps telling invalid HTML. any sugesstions how to work around it ?
- Icey5 years agoCommunity Support
Hi CP4L21 ,
Please refer to this blog to provide some sample data and your expected result:
How to provide sample data in the Power BI Forum - Microsoft Power BI Community.
Please remove sensitive information.
Best Regards,
Icey
- AlB5 years agoCommunity Champion
There seems to be a problem over the last days. I've heard several people complaining about that HTML error message. It usually works fine.
Share a file (Excel for instance) with the tables in it.
You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.