Forum Discussion

lea_313's avatar
lea_313
Icon for Helper I rankHelper I
4 years ago

Convert Excel Sumifs into DAX in Power bi

Hi all   I am in the process of converting a data set in Excel to Power bi. I have done most of the transition but am stuck on this last part and its a huge value to me so I need to find a way to r...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, lea_313 

 

Is the above formula useful to you?  My efforts are meaningful if it is helpful to you and you will be consider marking it as Answered since it is working now.

 

Regarding your current question, if I understand your question correctly, please use the following formula.

Count = 
COUNTA(Deliverer[Deliverer 1 ID])+COUNTA(Deliverer[Deliverer 2 ID])+COUNTA(Deliverer[Deliverer 3 ID])

 

Result:

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lea_313's avatar
lea_313
Icon for Helper I rankHelper I
4 years ago

Hiya

 

This doesnt seem to do the calculation per row? I just get a total for the whole column?

 

Thanks

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    I would like to make a column that based on the id I calculate the days of the month that that person attended.

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi,  lea_313 

     

    This makes me a little confused, is this not what you want?

    If not, could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented?


    If I can be absolutely clear about what you want to do, I think I might get a solution.

    And it would be great if my first formula can work for your initial problem.

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.