Forum Discussion
Data reporting question
Not sure if the output you described is what I am looking for. I want the final report to look like a spreadsheet with each date of the requested period listed in the first column with 15 or 20 other columns labeled with a combination of location and parameter. Each row will represent a date and any location parameter combination that I have a column set up will have the value on the row with the date. Each row may have a value for 1 or all of the columns or possibly there will be no data at all for some dates. There will never be more than one value for any date/location/parameter combination.
Thanks again
Richard
Hi Mickeyfinn
I just want to confirm if you tried solution mentioned by mahoneypat? And if you have resolved this question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please let me know.
-
Attached the following questions:
What's your current data and what's the expected outcome? Could you show their pictures? It may be more intuitive and reliable to explain with pictures.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.