Forum Discussion

sw123's avatar
sw123
Helper III
3 years ago
Solved

Price valid today

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!

Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:

     

9 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    3 years ago

    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's avatar
      sw123
      Helper III
      3 years ago

      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?

    • sw123's avatar
      sw123
      Helper III
      3 years ago

      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's avatar
        FreemanZ
        Super User
        3 years ago

        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: