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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,216,116
Messages
6,128,930
Members
449,479
Latest member
nana abanyin

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