Create a New Table in Dax


  • I have an item table with two dates associated with each item.  My table looks like this:

    I would like to use DAX in PowerPivot to create a table that looks like this:

    Any idea how I could do this in DAX? In my head I have been playing around with the CROSSJOIN and GENERATE functions but they don't seem to be the right fit.


    Sunday, March 24, 2013 6:42 PM


  • David,

    This is well outside my expertise but there's a very detailed post by Jason here that I think will help you. Although he is looking at combining 2 different tables I suspect you can adapt for your purposes by thinking of your table as 2 different tables.

    Without knowing what your end goal is I don't know whether its relevant but if what you are aiming for is a flattened fact table then you might be better trying to deal with it on import - e.g. the SQL UNPIVOT function can be used here and that will certainly save you any performance issues that this method could cause.


    Monday, March 25, 2013 5:33 AM