Prompt Almanac

Create intermediate Works with: Any AI

Power BI Date Table and Time Intelligence Walkthrough

Table output

Build a calendar and use it for year-to-date and comparisons.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Rate this prompt

Loading ratings…

Help me set up a date table and time intelligence in Power BI. Date range of my data: [DATE_RANGE]. Fiscal year start month: [FISCAL_START]. Weeks and holidays I care about: [WEEKS_AND_HOLIDAYS]. Measures I want: [MEASURES_WANTED].

Explain in simple words why a separate date table is needed, how to create it (with DAX or Power Query) [VERIFY], the columns to include, and how to mark it as the date table. Write measures for year-to-date, month-to-date, previous year, previous month and percentage change in a table with formula, meaning and test; example: sales of 120 this month against 100 last month is +20 percent. Mark every formula [VERIFY]. List the traps: gaps in dates, a date table that does not cover all data, relationships to several date columns, and text dates.

Test: pick three dates, compute the expected value by hand, and compare. Keep the explanation in plain words, and show what each measure returns for a month with no data so I know how blanks behave. Tell me which measure to build first to prove the date table works.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts