Forum Discussion
Show different date dimension on two axis
What you can do is:
1. In order table, merge to Conversion_Date table to get the new PromisedShipDate.Date, which is a DateTime format column;Merge to Conversion_Date table again to get the new ActualShipDate.Date
2. add columns in the Order table with Name : [Feb-19], [Mrt-19],[Apr-19] etc, the Power Query M language script will be like = if Date.Month([ActualShipDate.Date]) = 2 then [Quantity] else 0.
3. create a table in report view with columns you need.
Super UserAnonymous i'm not fully sue what you mean, when the quantity is blank it is not going to show the month, may be i'm missing something here.
I see it's a bit confusing parry2k ... in this concrete example there's one order placed on 10th of January, which is allocated to contracts from dec/jan/feb/mar.
I would like to see the order number and the order date (10th of Jan) in one row as headers, and the contract allocation in the column headers.
All the dates are in the whacky format so I can't just add the column from the source table..
Does that clarify?