Create a table with a current date column as header with conditions

[SH-VE]

I need to achieve this:

Customer in first Col; Month/Year as major header; WAP (average price), Quantity and Sales as the minor header

At present , My BI data is in this format

How can i have a date header and then do a sumif formula so that I am able to sum-up the quantity and sales for a particular customer in a given month.

Thanks for your help in advance. I have just started using Power BI and relying on community help!

[v-frfei-msft · Accepted solution]

Hi @SH-VE ,

We can create a matrix visual to work on it. Please check the pbix as attached. If it doesn't meet your requirement, Kindly share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank