Create Calculated Column COUNT RECORD ENTRIES FOR EACH ID BY ROUTING BRANCH

Anything related to PowerPivot and DAX Formuale
SKY
Posts: 1
Joined: Mon Dec 31, 2018 6:20 pm

Create Calculated Column COUNT RECORD ENTRIES FOR EACH ID BY ROUTING BRANCH

Postby SKY » Mon Dec 31, 2018 6:40 pm

HI,

I quite new with DAX and PowerPivot (3 weeks). I need to replicated an excel formula to DAX formula. The screenshot of excel file which I want to achieved by utilizing DAX formula as below.

I have two (2) existing column namely ROUTING BRANCH and APPROVER OFFICER . (Light Blue Color)

I want to create new calculated column which are:- COUNT RECORD ENTRIES FOR EACH ID BY ROUTING BRANCH and FIND MAX COUNT FOR EACH ID ATTACH TO WHICH APPROVAL BRANCH.


Result are shown in Light Orange Color.

I also attach together the EXCEL file.


How to replicate excel formula to DAX formula to achieved desire result as shown in those two(2) columns (Highlighted in Light Orange Color)

123.png
123.png (188.34 KiB) Viewed 199 times


I hope that I explain it well.


Thanks guys.
Attachments
DITERMINE_LATEST_POSSIBLE_BRANCH_BY_APPROVAL_OFFICER_0.3.xlsx
(12.19 KiB) Downloaded 18 times

MattAllington
Posts: 1015
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Create Calculated Column COUNT RECORD ENTRIES FOR EACH ID BY ROUTING BRANCH

Postby MattAllington » Tue Jan 01, 2019 7:16 am

Welcome to a whole new world. Generally speaking my advice is that you don’t think about this as “how do I replicate this Excel formula” but instead think about it as “I have a new tool, what is the best way to solve my problem”.

I have a lot of articles that cover the basic concepts. https://exceleratorbi.com.au/knowledge-base/

Just use the sub menu to find them. I specifically recommend you read these
https://exceleratorbi.com.au/calculated ... sures-dax/
https://exceleratorbi.com.au/the-optima ... ivot-data/

After reading those, have a rethink about your problem with a new lens and then ask any new questions you may have
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests