Forum Discussion
Column DAX query
I am having data as per the below table Product Date Category Alpha 25-02-2023 Service Alpha 17-02-2023 Service Alpha 06-02-2023 Purchase Beta 05-02-2023 Purchase Beta 2...
Thanks
but i am getting this output with your query
| Product | Date | Category | New Category |
| Alpha | 25-02-2023 | Service | Service_1 |
| Alpha | 17-02-2023 | Service | Service_1 |
| Alpha | 06-02-2023 | Purchase | Purchase |
| Beta | 05-02-2023 | Purchase | Purchase |
| Beta | 25-02-2023 | Service | Service_1 |
| Gama | 22-02-2023 | Service | Service_1 |
| Gama | 16-02-2023 | Service | Service_1 |
| Gama | 21-01-2023 | Purchase | Purchase |
| Gama | 17-02-2023 | Service | Service_1 |
Output is not unique...
| Product | Date | Category | New Category |
| Delta | 17-02-23 | Puchase | Purchase |
| Delta | 05-02-23 | Service | Service_1 |
| Delta | 06-02-23 | Service | Service_1 |
| Delta | 16-02-23 | Service | Sercvice_3 |