Forum Discussion

dimotori's avatar
dimotori
Frequent Visitor
1 year ago
Solved

Dynamic date substitution

Hi, implementing write back with PowerApps have two tables one with order number, amount and requested delivery dates (table 1) another with order number and confirmed delivery date (table 2).  Table...
DAX Direct Query
PowerApp write back
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi dimotori ,

    I’ve included the measure as you recommended and attached the file. Please review it when you have a chance and let me know if everything is correct.

     

    Hope this is helpful.

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi dimotori ,

I tested this scenario with sample data, and the logic works as expected. When a confirmed delivery date is available, the corresponding amount is displayed otherwise, it defaults to the requested delivery date.

I validated the results using a table visual both the placement of values and the total amounts are accurate and meet the requirements.

FYI:

 

I’ve attached the .pbix file for you to review the DAX logic and model relationships. Let me know if you'd like to see this in a matrix visual or explore any enhancements.

 

Regards,

Yugandhar.

dimotori's avatar
dimotori
Frequent Visitor
1 year ago

Hi, thank you for looking into this as well, however in the proposed solution date is not populating neither.

same as in your screenshot, confirmed date for order A001 is June 25, while in matrix table it pulls June 24, as it is in "Order table".

 

Besides, proposed LOOKUPVALUE function will not work well in Direct Query mode i have for Confirmed date table

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi dimotori ,
    Thank you for the follow-up. We are happy to assist you!
    Please refer the attached screenshot and file for your reference.

    I hope this resolve your query.
    Thank you.

    • dimotori's avatar
      dimotori
      Frequent Visitor
      1 year ago

      Thanks, v-pagayam-msft,

      unfortunately calculated column will not work in direct query mode, needs to be a measure.

       

      thanks for effort, though

      • V-yubandi-msft's avatar
        V-yubandi-msft
        Community Support
        1 year ago

        Hi dimotori ,

        I’ve included the measure as you recommended and attached the file. Please review it when you have a chance and let me know if everything is correct.

         

        Hope this is helpful.