Forum Discussion

Yael's avatar
Yael
Icon for Helper IV rankHelper IV
8 years ago

DAX - max function that takes filters into consideration dynamically

Hello,   Need help with DAX function please. Below is a pic of my data source, I'm interested in populating the field "Is Maximum Date" with 1 / 0 values. Row Number Date Transaction Number ...
Need Help
Yael's avatar
Yael
Icon for Helper IV rankHelper IV
8 years ago

Now I recieve 1 in one row only, but the fact still displays rows for all dates (even those which don't exist in the fact):

Yael's avatar
Yael
Icon for Helper IV rankHelper IV
8 years ago

Any other ideas on how we can create a general function that calculates MAX and Min according to values in filters / slicers?