Forum Discussion
Problem with data consolidation
The image attached is the data. I want to group all the fields by date and visualize (occupied/occupied+empty) of only the types FNS, R10, and R21(total, not individually). Can someone please help me with it? I've tried Group By, Summarize Columns without much success.
6 Replies
Hi Anonymous ,
In your scenario, I will use DAX to handle it, we can use summarize() and filter() function to do that, in PowerQuery, we can also filter the data with types FNS, R10, and R21, then use group, we can only create tables for each column you want to group.
By the way, it wolud be nice if you can share your data with txt or csv rather than a picture.
Best Regards,
Teige
Hey, Thanks for the response. The data in the .txt file is not formatted according to the requirements. This is post formatting. I tried those function, but I guess I am making a mistake somewhere. Is it possible for you to send the DAX code?
Hey,
Thanks for the help vivran22 . The measure solves the problem, I had an issue grouping by date and that's solved as well!
