Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Find alternative price

Hi all.


I have this measure to calculate the total sales based on a price list.


The thing is that my date range starts before "ItemPrice[StartDate]" on some items.

When this occures want the oldest price on the item to be used.

For example if StartDate is 01.02.2023 and EndDate is 20.02.2023, on the date 15.01.2023 i want the value on 01.02.23-20.02.23 to be used, because there is no older dates in StartDate for this item.



NewSales = 
    SUMX (
        FILTER (
            ItemPrice[StartDate] <= DateTable[Date]
                && ItemPrice[NewEndDate] >= DateTable[Date]
        [SalesQuantity] * 'ItemPrice'[Price]


Super User
Super User

read about the usage of MIN() with two parameters.

Thank you @lbendlin !
Is it possible for you to show me how to use MIN() in my measure?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors