Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Experts,
With SUMMARIZECOLUMNS wants to create a new table. There are two columns that would be used for filtering. One text column and one date column. The filter context is all text that starts with “Certified” and dates in 2022 year. What is the Dax ?
I guess it should be something like following:
Certified List = SUMMARIZECOLUMNS('Table1'[Col1],'Table1'[Col2],'Table1'[Col3],
FILTER('Table1',[Col1] in {"Certified" && " "}),
DATESBETWEEN(Table1[date],01 01 2020, 31 12 2020)
But it is not completely correct.
Solved! Go to Solution.
Hi @koorosh ,
Pls try this:-
Certified List =
SUMMARIZECOLUMNS (
'Table1'[Col1],
'Table1'[Col2],
'Table1'[Col3],
FILTER (
'Table1',
[Col1]
IN { "Certified", " " }
&& (
Table1[date] >= DATE ( 2020, 01, 01 )
&& Table1[date] <= DATE ( 2020, 12, 31 )
)
)
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Certified List =
SUMMARIZECOLUMNS (
'Table1'[Col1],
'Table1'[Col2],
'Table1'[Col3],
FILTER (
'Table1',
[Col1]
IN { "Certified", " " }))
On the first try, the first part does not work.
@koorosh , Try like
SUMMARIZECOLUMNS (
'Table1'[Col1],
'Table1'[Col2],
'Table1'[Col3],
FILTER (
'Table1',
[Col1]
IN { "Certified", " " } || isblank('Table1'[Col1]) ))
No Amit. Does not work.
Certified List =
SUMMARIZECOLUMNS('Table1'[Col1],'Table1'[Col2],'Table1'[Col3],
FILTER('Table1'[Col1] IN {"Certified"," "}||ISBLANK('Table1'[Col1]))
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |