The syntax of a properly defined tag is as follows:

{p<tag>#:<prompt>}

Where:

• <tag> is the lowercase 3 letter code for the type of tag you wish to use
• # is a value from 1-9 indicating the number of the specific tag of this type. (This allows re-using the same tag later without prompting the user for the entry a second time.)
• <prompt> is the prompt you would like to show to the user. Please keep in mind that the only acceptable characters in this area are values from 0-9, a-z, A-Z, and the -, ( and ) characters.

Every item supports defining prompts for both Text and Value elements. These are defined in the item’s formula as follows:

• Text:  {ptxt#:prompt}
• Value: {pval#:prompt}

For example:

#”Filtered Rows” = Table.SelectRows(#”Grouped Rows”, each ([Year] = {pval1:Enter a value}) and ([Location] = “{ptxt1:Enter text}“))

In addition to the ability to prompt for Text and Value prompts, Queries also support the qry tag, which will prompt the user for the name of a query. It is defined in the following format:

• Query: {pqry#:prompt}

For example:

Source = {pqry1:Name of data source query},

In addition to the ability to prompt for Text and Value prompts, DAX measures also support tags for the following items:

• Measure Name: {pmsr#:prompt}
• Table Name: {ptbl#:prompt}
• Column Name: {pcol#:prompt}
• Qualified Column: {pqtc#:prompt}

For example:

=TOTALMTD({pmsr1:Enter Measure name}],
{pqtc1:Enter calendar table name}
)

In addition to the ability to prompt for Text and Value prompts, Formulas also support tags for the following items:

• Cell Contents: {pcfx#:prompt}
• Cell Reference – Fully Absolute: {pcaa#:prompt}
• Cell Reference – Abs Col, Rel Row: {pcar#:prompt}
• Cell Reference – Rel Col, Abs Row: {pcra#:prompt}
• Cell Reference – Fully Relative: {pcrr#:prompt}
• Worksheet Name: {pcws#:prompt}
• Qualified Reference – Fully Absolute: {pwaa#:prompt}
• Qualified Reference – Abs Col, Rel Row: {pwar#:prompt}
• Qualified Reference – Rel Col, Abs Row: {pwra#:prompt}
• Qualified Reference – Fully Relative: {pwrr#:prompt}

For example:

={pcaa1:Hrs Per Day}*{pcar1:Wage Rate}
*DAY({pcra1:Month End})+{pwrr1:Relative ref new sheet}