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] ) )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your help!
I just had a query, for the "Sales Total:" DAX command, how would that be altered if there wasn't anything to sum up. For example, if the chart was composed of peoples' name, date of birth or other values that are unable to be summed?

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] ) )
)