Forum Discussion

alfredorhz's avatar
alfredorhz
Icon for Helper I rankHelper I
4 years ago
Solved

Help with a calculate column from 3 columns

Hi Power Bi, Community, I hope everyone doing well
I need some help to create a calculate column or measure with this data, Could you please help me?

Thanks

Calculated columns
Help with DAX Measure
  • amitchandak's avatar
    amitchandak
    4 years ago

    alfredorhz , for this have column month number

     

    Switch(true() ,

    [Month no] <=3, [1 three],

    [Month no] <=7, [2 Four],

    [3 Five])

     

     

    or

     

    Switch(true() ,

    [Month] in {"Jan", "Feb", "Mar"},  [1 three],

    [Month] in {"Apr", "may", "Jun", "Jul"}, [2 Four],

    [3 Five])

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    alfredorhz , for this have column month number

     

    Switch(true() ,

    [Month no] <=3, [1 three],

    [Month no] <=7, [2 Four],

    [3 Five])

     

     

    or

     

    Switch(true() ,

    [Month] in {"Jan", "Feb", "Mar"},  [1 three],

    [Month] in {"Apr", "may", "Jun", "Jul"}, [2 Four],

    [3 Five])