Forum Discussion

EmilyM2019's avatar
EmilyM2019
Icon for Helper II rankHelper II
6 years ago
Solved

Dax help

Hello,   I need help with a simple calculation. In my data source I have 2 date count columns, one is working days and one is calendar days.    I then have a field with a customer. I want a new c...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    Add a column

    ColumnAdded = SWITCH(TableX[Customer],  "A", TableX[Working days count], 
                                        "B", TableX[Calendar days count],
                                      0)
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

Add a column

ColumnAdded = SWITCH(TableX[Customer],  "A", TableX[Working days count], 
                                        "B", TableX[Calendar days count],
                                      0)
EmilyM2019's avatar
EmilyM2019
Icon for Helper II rankHelper II
6 years ago

Thanks for the help. This worked perfectly.