Forum Discussion

maclura's avatar
maclura
Resolver I
4 years ago
Solved

Create missing records for missing dates

Hi, I know there are many questions like this, but I don't have enough DAX to customize them to solve my problem.   In short, I have this daily summary table and I need to transform it lik...
DAX
Missing Dates
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Once you have the cross join, one option to populate the columns is with a LOOKUPVALUE.

     

    For example:

    Val1 =
LOOKUPVALUE (
    Summary[Val1],
    Summary[ID], Transform[ID],
    Summary[Date], Transform[Date],
    0
)
maclura's avatar
maclura
Resolver I
4 years ago

Thank you amitchandak 
Even if this is not the solution to my problem, thanks to your suggested links, I refreshed a bit my knowledge on join types. Very interesting the article on DAX join with related or not related tables!

For my situation the CROSSJOIN (cartesian product of 2 tables) is the only solution to avoid losing "date" records.

Thank you for your input, you deserve a Kudo!

maclura