Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date filtering

Hi!   I'm relatively new to Power Bi and was having trouble with implementing a date filter.    The task is to have a date filter that only show data that falls before but NOT including the selct...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the attached file.

    I changed a relationship type.

     

    Name measure: = 
CALCULATE (
    SELECTEDVALUE ( data[name] ),
    FILTER ( data, data[date] < MAX ( 'Calendar'[date] ) )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Thank you for your feedback.

I think you can use other function, instead of SUM, for instance, selectedvalue / min / max / and so forth.

Please share your sample pbix file, and then more accurate solution can be written.

Thanks.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    Please check the attached file.

    I changed a relationship type.

     

    Name measure: = 
CALCULATE (
    SELECTEDVALUE ( data[name] ),
    FILTER ( data, data[date] < MAX ( 'Calendar'[date] ) )
)