I could tackle this using measures but for various reasons I prefer to create a table in my Model, and do it using Dax. Here is a simple example table which shows a list of sales orders, the price of that sales order and the dates the service will be delivered
I would like to arrive at this output in a table
I have tried the following (amongst other things) which demonstrates better what i try to do (I can figure out easy how to put amount in there so just focusing on getting dates)
SUMMARIZECOLUMNS( Test[Sales Order],Test[From],Test[To], "Series",GENERATESERIES(MAX(Test[From]),MAX(Test[To]),1) )
The key here is i dont want a Cross join table with every single date/Sales order combination possible as it will be huge.
I would be hugely grateful if anyone has a nice solution to this or let me know if something similar is in Sam’s resources that i perhaps missed.
Thanks in advance for reading