Forum Discussion

PP_DP's avatar
PP_DP
Frequent Visitor
5 years ago
Solved

distinct Customer this month

Hi All,        I am new to PowerBI & Dax, please help me i can count Customer is not dintinct in this month per day and per week    To achieve this, I have created an Customer Table, Master Date ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi PP_DP ，

    Base on the table you provide,you could try the following steps:

    Mon

    Mon = RIGHT('Table'[DAY],3)

    Day

    Day1 = LEFT('Table'[DAY],LEN('Table'[DAY])-4)

    Count:

    COUNT = DISTINCTCOUNT('Table'[Cus name])

    Final create visualization:

     

     

    Wish it is helpful for you!

     

    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi PP_DP ，

Base on the table you provide,you could try the following steps:

Mon

Mon = RIGHT('Table'[DAY],3)

Day

Day1 = LEFT('Table'[DAY],LEN('Table'[DAY])-4)

Count:

COUNT = DISTINCTCOUNT('Table'[Cus name])

Final create visualization:

 

 

Wish it is helpful for you!

 

Best Regards

Lucien