Solved: Field=MAX(Field)

clem312 · ‎10-16-2021

Hi,

I often see filters like this [Field]=MAX([Field]).

Can someone explain me the action it makes and what it's useful for ?

Fowmy · ‎10-17-2021

@clem312

In the example below, I have created a running total. With the FILTER function, I am iterating the date column one row at a time and compare with the date that is visible outside the filter function using the MAX function. the aggregator function (MAX) in this case helps me grab the date from the visual.

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Fowmy · ‎10-17-2021

@clem312

In the example below, I have created a running total. With the FILTER function, I am iterating the date column one row at a time and compare with the date that is visible outside the filter function using the MAX function. the aggregator function (MAX) in this case helps me grab the date from the visual.

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group