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
)
AlexisOlson's avatar
AlexisOlson
Super User
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

    Dear AlexisOlson ,

    LOOKUPVALUE just works great! It's the solution to my problem.

    It also allows me to avoid to SUMMARIZE duplicate entries in the source table. This is great!

    Thank you.

    maclura