Hi,
I am trying to use PowerBi to show performance measures for my data. My problem is that when uploading my data from PQ to PowerBi my data is off. I have a large data set with headers- market, partner, sales, region, dates (1/1/2023 etc) which I don't like the dares as headers side note I want it to be years and months. But my data keeps showing count I want my data to be what I uploaded and to look at the sum as well. This is definitely something I am having an issue with. Please advise!!
I suspect that this related to your other question. Link below.
https://www.myonlinetraininghub.com/excel-forum/power-query/headers-as-dates
Hi Rinny, yes, this is related I have tried countless times and it is not flowing right. I tried in excel and PowerBi to get this correct.
Hi,
Please supply some sample data and explain exactly how your data 'is off'.
What are you trying to do with it? What is the result you are after? Provide examples of this result.
Without these things we are just imagining what you are doing and it's really, really hard to help you.
Phil
