Forum Discussion
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-msftCommunity Support
Hi Anonymous ,
Could you pls provide some sample data with expected output for test?
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
- AnonymousNot applicable
- v-kelly-msftCommunity 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,
KellyDid I answer your question? Mark my reply as a solution!