Tag: dynamic

• Excel and Power BI

  Customized dynamic time matrix visual in Power BI

  

  customized dynamic time matrix in Power BI using DAX

  Apr 5, 2021
• Excel and Power BI

  A smarter multi criteria VLOOKUP in Excel

  

  Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.

  Mar 31, 2021