Forum Discussion
Grouping table by multiple columns
Anonymous - OK, this involved creating a series of columns. Your dates mess me up a little but should work fine in your region settings. See attached PBIX below sig. You want Page 21 and Table (21).
Hey @Greg_Deckler , here is the table in plain text.
Tried adding it in table but it marks the post as spam:
Customer Product Serial (random GUID) StartDate EndDate Period (M) Free / Subscription
A WA 15685 1/1/2019 31/12/2019 12 Free
A WA 67732 1/1/2020 31/5/2020 5 Free
A WA 12114 1/6/2020 30/6/2020 1 Sub
A WA 60719 1/7/2020 30/6/2021 12 Sub
A QWS 32789 1/1/2019 31/12/2019 12 Free
A KS 48065 1/7/2020 30/6/2021 12 Sub
B WA 18944 1/1/2020 31/5/2020 5 Free
B WA 56311 1/6/2020 30/6/2020 1 Sub
B KS 77724 1/7/2020 30/6/2021 12 Sub
C QWS 19615 1/7/2020 30/6/2021 12 Sub
C WA 70867 1/7/2020 30/6/2021 12 Sub
D WA 30656 1/6/2020 30/6/2020 1 Sub
| Customer | Product | Serial (random GUID) | StartDate | EndDate | Period (M) | Free / Subscription |
| A | WA | 15685 | 1/1/2019 | 31/12/2019 | 12 | Free |
| A | WA | 67732 | 1/1/2020 | 31/5/2020 | 5 | Free |
| A | WA | 12114 | 1/6/2020 | 30/6/2020 | 1 | Sub |
| A | WA | 60719 | 1/7/2020 | 30/6/2021 | 12 | Sub |
| A | QWS | 32789 | 1/1/2019 | 31/12/2019 | 12 | Free |
| A | KS | 48065 | 1/7/2020 | 30/6/2021 | 12 | Sub |
| B | WA | 18944 | 1/1/2020 | 31/5/2020 | 5 | Free |
| B | WA | 56311 | 1/6/2020 | 30/6/2020 | 1 | Sub |
| B | KS | 77724 | 1/7/2020 | 30/6/2021 | 12 | Sub |
| C | QWS | 19615 | 1/7/2020 | 30/6/2021 | 12 | Sub |
| C | WA | 70867 | 1/7/2020 | 30/6/2021 | 12 | Sub |
| D | WA | 30656 | 1/6/2020 | 30/6/2020 | 1 | Sub |