Calculate number of orders per month in calculated column

L

Legacy 221383

Guest
Hi,

I have a problem with PowerPivot that I cannot seem to solve...
This is the PowerPivot table that I have:
Order IDCustomerMonth
110001
220001
310001
430001
520001
610001
730001
810002
920002

<tbody>
</tbody>

What I need is a column that tells me Order ID 1 is customer 1000's 1. order in month 1 and so forth... This should then look like this:
Order IDCustomerMonthOrder in month
1100011. order
2200011. order
3100012. order
4300011. order
5200012. order
6100013. order
7300012. order
8100021. order
9200021. order

<tbody>
</tbody>

In Excel I would use the following formula in column D: =COUNTIFS($B$2:$B2;B2;$C$2:$C2;C2) &". order" to get my desired result. But I cannot figure out how to get this done in DAX so that I can have a calculated column in my PowerPivot table.

Thank you very much for any help to get me closer to my goal!
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,216,119
Messages
6,128,947
Members
449,480
Latest member
yesitisasport

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top