Excel, SAP, Oracle & automation tips — plus wacky facts
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Cumulative totals, running counts, running totals by category and month-to-date sums — with expanding ranges, SUMIFS, Excel Table formulas and the new SCAN function…
Read article →Stop writing Sales!K2:K81 everywhere. Name your ranges or turn data into an Excel Table so formulas read like =SUM(Amount) and grow with new rows.
Read article →The TEXT function turns numbers and dates into exactly the text you want: dd-mmm-yyyy, day names, leading zeros, lakh/crore commas, percentages and times. 20…
Read article →Final project: targets without a relationship via TREATAS, % of target with status, months above average, FYTD trend and an RLS-ready one-page report.
Read article →Make reports explorable: right-click drill-through to a customer page, report-page tooltips with a mini chart, and bookmarks with buttons to switch views.
Read article →Show each regional manager only their region's data: static roles, dynamic RLS with USERPRINCIPALNAME and a user table, and how to test with View…
Read article →Titles that say what is selected with SELECTEDVALUE, and one chart that switches between Sales, Profit and Orders with a field parameter.
Read article →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 →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 →Row-by-row calculations with SUMX for profit, AVERAGEX for averages per customer, and RANKX for top-N rankings that respect filters.
Read article →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 →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 →
