Price valid today

[sw123]

Hi,

I have a pricelist-table with different pricelists. All pricelists contain prices for items and an start date and an end date for each price / item. How do I show only prices that are valid today in Power BI?

Thanx in advance!

[FreemanZ]

hi @sw123 

what do you mean by "show"? How does your expected result look like?

[sw123]

Hi, I want to create a table in Power BI, that shows a list of the items and the prices that are valid today (today is on or between the beginning date and end date).

[FreemanZ · Accepted solution]

hi @sw123 

supposing your table looks like:

try plot a table visual with all the columns and feed a measure to the filter pane like:

Measure = 
IF(
    MAX(TableName[startdate]) <= TODAY()
        &&MAX(TableName[enddate]) >= TODAY(),
    1,0
)

it worked like:

[sw123]

Yes, this works great. But it did display the next problem 😄

We seem to have multiple prices in the price list for the same item, that seem to be valid today, but then actually only the one with the latest beginning date should show in the table.

For example, when the table looks like this:

It seems that all the prices are valid today, but should only show the ones with start date 3/1/2023. Can you help, with this issue also?

[FreemanZ]

hi @sw123 

then try like:

Measure = 
VAR _maxdate =
MAXX(
        ALL(TableName[startdate]),
        TableName[startdate]
)
RETURN
IF(
    MAX(TableName[startdate]) <= TODAY()
        &&MAX(TableName[startdate]) = _maxdate
        &&MAX(TableName[enddate]) >= TODAY(),
    1,0
)

[sw123]

Hi,

This doesn´t return anything for me with filter 1. Do you have any idea what could be wrong?

Measure =

VAR _maxdate =

MAXX(

        ALL('Price list'[BegDate]),

        'Price list'[BegDate]

)

RETURN

IF(

    MAX('Price list'[BegDate]) <= TODAY()

        &&MAX('Price list'[BegDate]) = _maxdate

        &&MAX('Price list'[EndDate]) >= TODAY(),

    1,0

)

[sw123]

Hi,

I am returning to this. Can anyone help me with what is wrong with ny measure and why it doesn´t return anything?

[rajendraongole1]

Hi @sw123 

Just create a new measure [Today Sales] as below:

Today Sales = CALCULATE([Total Sales],FILTER(Table1,Table1[Date]=TODAY()))

Try above and let know if it solves or not

[sw123]

Hi, there are two dates in the table, one beginning date and one ending date. And I want to show the prices that are valid today (today is on or between beginning date and end date). Can you still help me out?