How to link dynamic product prices with order dates in power bi? RRS feed

  • Question

  • Hello,

    I have a Product price list table which is ever changing with following columns.


    Whenever price changes for a product, the date will be mentioned with the product and updated price.

    I have a Sales table with:

    OrderNo--OderDate--Product-- Qty--Price--SalesLineTotal

    I need to point to the latest product price according to the OrderDate in the Sales table.

    Please click here for the sample data

    thanks a lot


    • Edited by Arjun M Shetty Thursday, April 18, 2019 10:08 AM small typo
    Thursday, April 18, 2019 10:07 AM

All replies