Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am trying to create a table (later will be used with a union for sankey diagram) with SUMMARIZE with a static column.
my table = SUMMARIZE(FILTER(pmt, pmt[Method Of Payment] = "AMOP" && pmt[Transaction Type] = "Authorization" && pmt[Step] = "Validation"),"CUSTOM NAME", "FIX VALUE", pmt[Step], "count", COUNT(pmt[PRI]))
where I want to add a column "CUSTOM NAME" with a fix value"FIX VALUE", I am unable to do so.
I can only add it after the COUNT(pmt[PRI]).
How can I add it the way I want, or I do I reorder it after doing a summarize
Solved! Go to Solution.
@datobi Maybe:
my table =
SUMMARIZE(
FILTER(pmt, pmt[Method Of Payment] = "AMOP" && pmt[Transaction Type] = "Authorization" && pmt[Step] = "Validation"),
pmt[Step],
"CUSTOM NAME", "FIX VALUE",
"count", COUNT(pmt[PRI])
)
Thanks, I am just over complicating things when there is just a simple solution
@datobi No worries, sometimes just takes another set of eyes.
@datobi Maybe:
my table =
SUMMARIZE(
FILTER(pmt, pmt[Method Of Payment] = "AMOP" && pmt[Transaction Type] = "Authorization" && pmt[Step] = "Validation"),
pmt[Step],
"CUSTOM NAME", "FIX VALUE",
"count", COUNT(pmt[PRI])
)