Power BI DAX #5: SUMMARIZE
I once facilitated a Power BI training where the participants needed to generate a new table from the sales transaction data (that comes from the ERP) in such a way…
How To Automatically Pull In New Report Data Into Excel Using PowerQuery
One common situation most users of Excel face in making recurrent reports -- daily reports, weekly reports, monthly reports etc -- is that of updating the raw data part of…
Power BI DAX #4: CALENDAR, every sales/operations analyst friend
If there exists a book of ten commandments for Power BI, one of the commandments will be -- always have a date table.A date table is a table that has…
Power BI DAX #3: VALUES, another must know DAX formula
One common situation sales analysts face is capturing newly introduced products or SKUs or Region or Sales Rep in their reports. In Excel, you'll have to do something extra --…