I have a data set that i want to show in Power BI and i need to take the max date and show it in 1 row. How can i write the formula in DAX to have the max date taking into account 2 different criterias (Bonus_Id and Quarter)?
When i use max date, it get the max date of all the column:
*update_src is the update date from the source
Please see the screenshots of the data and how it looks in Power BI
Thanks in advance