How to Add a custom date column on a Matrix

[Anonymous]

Hi All

Here's my situation. I have the following table

A sample of the values would look like this

My goal is to have a matrix with the field "Harvest" at the line and the sum of "Volume" and average of "price" at the value fields (so far so good) with a group of columns. The problem lies on that. I need one first collumn with the values of the contracts registraded at the time the rerport is beign generated. And other column with the same values but distributed on month and year of the "delivery_period".

Should looks something like this

But I cannot find how to create the collumn "Today's business". I tried to create two measures using calculate, but when I insert the measures on the table I receive a new column at the "Delivery Period" group. 

I'd appreciate any help I got.

Thanks everyone

[v-kelly-msft]

Hi @Anonymous ，

Could you pls provide some sample data with expected output for test?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Anonymous]

Hi @v-kelly-msft 

The data is like this sample.xlsx

And the output like this output.xlsx

[v-kelly-msft]

Hi @Anonymous ,

Have you checked my last reply?Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[v-kelly-msft]

Hi  @Anonymous ,

Sorry for the late reply.

I cant access your data,would you pls modify the link as public and reshare it?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!