Filter dates in a table using a measure (because creating a new column/table is not an option)

Question

Hi there,&nbsp;I have a list of book titles that have a wide range of onsale dates (ex: from 1975 til today). Creating a measure is the only option for me with this specific dashboard (I am not allowed to create a new column or table).&nbsp;What I need to do:&nbsp;In my POS table visual, I need to only show the data for titles that have an "onsale date" at least 1 month old. I need to use the measure as a "filter on this visual" or "on this page".&nbsp;What I have attempted: A LOT of different things. But in a nut shell, I've tried a variety of functions where I am telling the measure to look at the Onsale Date column in the Product Hierarchy Table and returning the Onsale dates that have a Start Date of 1 month before today. Since I need this automated when the data refreshes.&nbsp;Relationships:&nbsp;The Product Hierarchy table is connected to all of the POS data and many other data.&nbsp;My experience:&nbsp;I have only been working with PowerBI for 1 month. So I am not well versed in DAX.&nbsp;I look forward to any and all feedback. I have done a lot of research on line and in this forum and nothing has worked for me since.&nbsp;&nbsp;&nbsp;&nbsp;

sturlaws · Accepted Answer

Hi, ariana_night,&nbsp;based on the information you have provided, I have created a small sample report:&nbsp;with the measure looking like this:Last onsale date older than 1 month =
VAR _tmp =
    FILTER (
        'Table',
        'Table'[Onsale date]
            &lt;= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) )
    )
RETURN
    IF ( COUNTROWS ( _tmp ) &gt;= 1, 1, 0 )&nbsp;cheers,Sturla

Forum Discussion

Filter dates in a table using a measure (because creating a new column/table is not an option)

2 Replies

Related content

Creating custom columns keeps returning a structured Table column

Create a Column where sum two columns from different tables

Column created in a table appears in another table

Create a new table from columns from existing tables

Create a Calculated Column from Different Tables