Forum Discussion

ajaydavidluke's avatar
ajaydavidluke
Icon for Helper I rankHelper I
5 years ago

Getting a date from one table and into another

Good afternoon all,

 

I want to import a date 'Next Supply Base Prod'[Emb Estimated D] into 'Next Supply Date' table.

 

 

I would like then to create a dax based on:

 

if [Expected Delivery Date] is blank then show me [Emb Estimated Delivery Date] else [Expected Delivery Date].

 

Am I asking too much in this instance??

 

Many thanks in advance 🙂

 

 

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    I have an approach that might work well, but it depends on the following question. Does any Prod/Colour have a single 'Emb Estimated Delivery Date' or 'Expected Delivery Date' associated? If that is the case, you might try this formula. 

    Expected/Estimated Delivery Date =
VAR prod_colour = [Prod/Colour]
RETURN
    IF (
        [Expected Delivery Date] = BLANK (),
        CALCULATE (
            SELECTEDVALUE ( 'Next Supply Base Prod'[Emb Estimated Delivery Date] ),
            'Next Supply Base Prod'[Prod/Colour] = prod_colour
        ),
        [Expected Delivery Date]
    )


    Regards,

    Marc



    • ajaydavidluke's avatar
      ajaydavidluke
      Icon for Helper I rankHelper I
      5 years ago

      Hi Marc,  

       

      Thank you for your solution:  You can view the results below, I'm definitely closer but I should be expecting to see 'Next supply date' in the 'Expected/Estimated Delivery Date' column where 'Expected Delivery Date' is blank but I'm seeing the opposite to that?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi,

        In which table are you working? I do not see 'Next Supply Date' column in any table. Maybe i have not understood well the problem.

        Thanks,

        Marc