Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.LeanAndPractise(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] )
)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
29 | |
27 | |
18 | |
14 | |
14 |