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
Icon for Community Support rankCommunity Support
1 year ago

Hi dimotori ,

Thanks for sharing, Nasif_Azam the updated solution using TREATAS is an effective workaround it bypasses cross table filtering limitations by matching OrderNumber values between the two tables. This enables Power BI to evaluate the ConfirmedDeliveryDate from Table2 when available, and fall back to the RequestedDeliveryDate from Table1 when necessary.

 

I'd recommend testing this approach in your matrix visual with Calendar[Date] on the rows and the dynamic delivery amount measure in the values section. Let me know how it behaves in your report

 

Appreciate your continued contributions to the community Nasif_Azam .

 

Best regards,

Yugandhar.