Forum Discussion

prashantg364's avatar
prashantg364
Helper II
3 years ago

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...
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi prashantg364 

you may also try to add a column like:

Column = 
VAR _table = 
FILTER(
    TableName, 
    TableName[Product]=EARLIER(TableName[Product])
        &&TableName[Category]=EARLIER(TableName[Category])
)
VAR _index = RANKX(_table, [Date],,ASC)
RETURN
IF(
    COUNTROWS( _table)=1,
    [Category],
    [Category]&"_"&_index
)

 

it worked like: