Explain how you have used advanced DAX calculations in Power BI to solve a complex business logic requirement in the past.
