customized dynamic time matrix in Power BI using DAX
A smarter multi criteria VLOOKUP in Excel
Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.
democratizing data and analytics
customized dynamic time matrix in Power BI using DAX
Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.