Prompt:

dynamic title Previous

The Advanced Prompt Generation Service ā€” your reliable tool for crafting precise, structured, and detailed prompts for use across various AI platforms and services!

All prompts All categories
Prompt Content:
I need a dynamic title for the Previous card visuals. If [cal_year] is selected I want title to be Previous Year If a [cal_quarter] is selected I want it to say Previous Quarter

this is an example

Report Date Range Title w/o Cust Name = 
MIN('Date'[date_value]) & " - " &
MAX('Date'[date_value]) & " (" & 
IF(
    ISBLANK(SELECTEDVALUE('Date'[cal_quarter])),
    SELECTEDVALUE('Date'[cal_year]),
    SELECTEDVALUE('Date'[cal_quarter])
) & ")"
Run in App Add Prompt