Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to Add a custom date column on a Matrix

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

 

 

4 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support

    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!

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support

        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!