Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi Everyone
I have this DAX formula in order to create one new Table:
SUMMARIZE(fFLX,fFLX[CategoriaBDG],fFLX[G/L],fFLX[Period], "QTY", SUM(fFLX[Quantity]))
Thanks for the support!
=
CALCULATETABLE(
SUMMARIZECOLUMNS(
fFLX[CategoriaBDG],
fFLX[G/L],
fFLX[Period],
"QTY", SUM( fFLX[Quantity] )
),
fFLX[G/L] IN { 1, 2, 3 }
)
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Hi @MarcoMizz
Something like this
=
SUMMARIZE (
FILTER ( fFLX, fFLX[CategoriaBDG] IN { "Value1", "Value2", "Value3" } ),
fFLX[CategoriaBDG],
fFLX[G/L],
fFLX[Period],
"QTY", SUM ( fFLX[Quantity] )
)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
6 | |
3 | |
3 | |
3 |
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |