Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
My FACT TABLE has got a column 'Card Number',
4 'Card numbers' that are already grouped are: 'Remote start', 'gf-webpay', 'vc-WebPay' and 'Engineer'.
The issue is with million of the ones as in example shown below:
613657
534798
CYV-0011
TGFC7689
A89765
CVS785345
FL77564DF
How do I put all of these random numbers in one group or a bucket?
Thank you in advance.
Best,
J
@Anonymous , You need to create a column for that
like static-segmentation
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
Thank you amitchandak,
I am afraid the solution will not help my problem.
I must group items from within one column only.
Within the column there are 3 groups there already.
The column is million rows long.
In my column: 'Card number'
It has got millions of various CC numbers:
CC-002
CC-00024
CC-00089787
...etc. All these various CC numbers need to be grouped together.
Next Group:
Webpay1
Webpay2
VCWebpay
These three also need to be grouped.
Last but not least I have millions of rows in that column that are all very different. These are members number, e.g.:
CP678
B89789
EC-uiu-UK
KM8987ND7
How do I approach this please?
Thank you,
J
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |