Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App
Power BI Intermediate Lesson 9: Drill-Through, Tooltip Pages and Bookmarks

24 Dec 2024 · Power BI & DAX · 2 min read

Power BI Intermediate Lesson 9: Drill-Through, Tooltip Pages and Bookmarks

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 →
Power BI Intermediate Lesson 8: Row-Level Security (Static and Dynamic)

23 Dec 2024 · Power BI & DAX · 2 min read

Power BI Intermediate Lesson 8: Row-Level Security (Static and Dynamic)

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 as.

Read article →
Power BI Intermediate Lesson 7: Dynamic Titles and Field Parameters

22 Dec 2024 · Power BI & DAX · 2 min read

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 →
Power BI Intermediate Lesson 6: Two Dates – Inactive Relationships and USERELATIONSHIP

21 Dec 2024 · Power BI & DAX · 2 min read

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

20 Dec 2024 · Power BI & DAX · 2 min read

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 price.

Read article →
Power BI Intermediate Lesson 4: Iterators – SUMX, AVERAGEX and RANKX

19 Dec 2024 · Power BI & DAX · 2 min read

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

18 Dec 2024 · Excel Formulas · 2 min read

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 numbers, quarters, Indian financial year and date checks.

Read article →
Power BI Intermediate Lesson 3: Time Intelligence for the April-March Financial Year

18 Dec 2024 · Power BI & DAX · 2 min read

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

18 Dec 2024 · Excel for Finance · 2 min read

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, margins and month-on-month change.

Read article →
Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERS

17 Dec 2024 · Power BI & DAX · 2 min read

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

16 Dec 2024 · Power BI & DAX · 2 min read

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)

13 Dec 2024 · Excel Functions A–Z · 1 min read

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 →
Older posts
Newer posts
← Previous Page1 … Page49 Page50 Page51 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →