This is a huge win for those of us who try to use Power BI for market basket analysis. Here is a the link to documentation https://support.office.com/en-us/article/CONCATENATEX-Function-DAX-ae3ba882-c260-4a56-82d1-70ee66451b39 The tutorial on how to use this function for market basket analysis will be available shortly.
Month: April 2015
Power Query has a feature that can be used to drill into details. This is particularly useful when working with 32 bit excel. Sample workbook can be downloaded here. Here are the steps. For the purposes on the tutorial let’s load Sales data from an excel table (this could be from a database). Highlight Sales