Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm incredibly new to powerBI, only started last week,please be gentle!
I 4 calculated columns, each returning a unique date for a specific ID, it looks like this when I put it into as table:
ID | Date1 | Date2 | Date3 | Date4 |
1 | %DateValue% | |||
1 | %DateValue% | |||
1 | %DateValue% | |||
1 | %DateValue% |
It works, but it's very clunky, so I'd like to have it display like this:
ID | Date1 | Date2 | Date3 | Date4 |
1 | %DateValue% | %DateValue% | %DateValue% | %DateValue% |
2 | %DateValue% | %DateValue% | %DateValue% | %DateValue% |
3 | %DateValue% | %DateValue% | %DateValue% | %DateValue% |
4 | %DateValue% | %DateValue% | %DateValue% | %DateValue% |
I've been playing around with a few things, importing the data (from CSV) into another table and manipulating it there with relationships on the ID etc. but I just don't understand what's happening there well enough to get this working. Can anyone help?
Hi @BenMoores
You can do it easily in Power Query, go to Transform Data > select your table > Home > Group By > set everything as on the screenshot below and click ok.
also, see the attached for reference.
Thanks for the reply Mariusz 🙂 As the data is in calculated columns, I'm not able to bring that into the transform. I'll google and see if there's a way to do this but it seems it might not be possible
Hi @BenMoores
Instead of Calculated column, you can create a custom column in Power Query and perform group by ( as explained by @Mariusz )
You can read up here ( how to add a custom column in Power BI)
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-custom-column
Thanks
Deepak
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |