DAX - "Monthly Orders" For a Particular Customer?

[MaadiKemko]

Hi All,

As part of requirement, I want to create a Custom Table  (Historic Information) with below information in Power Bi Desktop. 

Can anyone help me to write DAX for the above mentioned columns(Monthly Order Details)?

I used the below option to create the table,

Please find the data below, 

Order Details

Customers

Let me know if you want any other information.

Thank in Advance,

Maadi.

[dataX · Accepted solution]

[dataX · Accepted solution]

[MaadiKemko]

Hi @dataX,

Thanks for you replay.

Is it possible the same information keep in a separate static table.

This table will act like a historic table and will use for trending.

I dont know how to create the table with calculated columns(Year, Month & count of Orders).

Let me know is it possible or not? If yes then how to do that?

Thanks in Advance,

Maadi.

[Phil_Seamark · Accepted solution]

Perhaps give this a go over your orders table

New Table = SUMMARIZE(
    ADDCOLUMNS(
        'Orders',
        "Year",YEAR('Orders'[Order Date]),
        "Month",MONTH('Orders'[Ship Date])
        )
        ,
        [Year],
        [Month],
        "Orders" , COUNTROWS('Orders')
        )

[MaadiKemko]

This is worked for me.

Thanks @Phil_Seamark & @dataX.