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.

     

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.