Power BI Intermediate Lesson 7: Dynamic Titles and Field Parameters
Titles that say what is selected with SELECTEDVALUE, and one chart that switches between Sales, Profit and Orders with a field parameter.
Read article →Atul Vij
Power BI Intermediate Lesson 6: Two Dates – Inactive Relationships and USERELATIONSHIP
Power BI Intermediate Lesson 6: Two Dates – Inactive Relationships and USERELATIONSHIP
Report sales by order date and by ship date from one Date table with an inactive relationship and USERELATIONSHIP, plus days-to-ship and cross-year orders.
Read article →Power BI Intermediate Lesson 5: Variables, DIVIDE and Readable DAX
Power BI Intermediate Lesson 5: Variables, DIVIDE and Readable DAX
Write DAX that others can read and debug: VAR/RETURN, DIVIDE instead of /, RELATED in iterators, and a discount analysis on list vs selling…
Read article →Power BI Intermediate Lesson 4: Iterators – SUMX, AVERAGEX and RANKX
Power BI Intermediate Lesson 4: Iterators – SUMX, AVERAGEX and RANKX
Row-by-row calculations with SUMX for profit, AVERAGEX for averages per customer, and RANKX for top-N rankings that respect filters.
Read article →Excel Date Formulas Cheat Sheet: 25 Formulas You Will Actually Use
Excel Date Formulas Cheat Sheet: 25 Formulas You Will Actually Use
The 25 Excel date formulas used most at work: today and month-end, adding months, age and tenure, working days with holidays, weekday names, week…
Read article →Power BI Intermediate Lesson 3: Time Intelligence for the April-March Financial Year
Power BI Intermediate Lesson 3: Time Intelligence for the April-March Financial Year
FYTD, last year and YoY % for an Indian April-March financial year with TOTALYTD and "3/31", SAMEPERIODLASTYEAR and a proper Date table.
Read article →Excel for Finance Lesson 4: Monthly MIS P&L From a GL Extract
Excel for Finance Lesson 4: Monthly MIS P&L From a GL Extract
Turn a general-ledger or trial-balance extract into a monthly P&L: map heads to groups, SUMIFS by month and type, gross profit, EBITDA, net profit,…
Read article →Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERS
Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERS
Region share of total, product share within its category and grand-total percentages that stay correct under slicers, with REMOVEFILTERS, ALL and ALLEXCEPT.
Read article →Power BI Intermediate Lesson 1: CALCULATE and Filter Context
Power BI Intermediate Lesson 1: CALCULATE and Filter Context
How CALCULATE adds and replaces filters, why a measure gives different results in each cell, and when KEEPFILTERS returns blank.
Read article →GAMMALN.PRECISE Function in Excel: Natural Log of Gamma (2010+ Version)
GAMMALN.PRECISE Function in Excel: Natural Log of Gamma (2010+ Version)
GAMMALN.PRECISE is the 2010 version of GAMMALN with the same result and improved accuracy.
Read article →Excel Lesson 18: Final Project — Build a Monthly Sales Report
Excel Lesson 18: Final Project — Build a Monthly Sales Report
Put the whole course together: turn raw orders into a one-page quarterly sales report with KPIs, region vs target with Met/Missed, a monthly chart,…
Read article →Excel Lesson 15: Data Validation and Drop-Down Lists
Excel Lesson 15: Data Validation and Drop-Down Lists
Stop typing mistakes before they happen: drop-down lists from a range or Table, whole-number and date limits, custom rules for PAN and mobile numbers,…
Read article →