Forum Discussion

manah77g's avatar
manah77g
Regular Visitor
1 year ago
Solved

Latest date filter

Dear Experts,  I have created a dashboard related to the population, and it updates daily. Now, I want to create a filter using the Page Filter available in the Filters pane so that it filters based...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi manah77g 

     

    Thank you very much Ritaf1983 for your prompt reply.

     

    Is your problem solved? If not, here are some solutions I can provide:

     

    Here's some dummy data

     

    “Table”

     

    If you want to implement page-level filtering, try:

     

    Create a column.

     

    Latest date = 
var _maxDate = CALCULATE(MAX('Table'[Date]), ALL('Table'))
RETURN
IF(
    'Table'[Date] = _maxDate,
    1,
    0
)

     

     

     

    If you want to implement visual-level filtering, try:

     

    Create a measure.

     

    Measure Latest date = 
var _maxDate = CALCULATE(MAX('Table'[Date]), ALL('Table'))
RETURN
IF(
    SELECTEDVALUE('Table'[Date]) = _maxDate,
    1,
    0
)

     

    Click the visual you want to filter:

     

     

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

Hi manah77g 
You can create flag column in your date table like :

max_date_check = if([Date]<= MAXX(RELATEDTABLE(orders),'orders'[Order Date]),1,0)

and use this flag as a filter:

The pbix with the example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.