Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX-SWITCH

Hello Folks ,
Here i wanted to assign numbers like 1, 2, 3 to a text column (>9 AM, >12 PM,>15 PM). For this I want to use Switch function to assign numbers. But it is not working. Please Help.

>9 AM1
>12 AM2
>15 AM3

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Anonymous What does your Time Group column look like? You might be able to use the TIME function but I won't know until I see your Time Group column. It seems like it is a number of some kind.