Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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]))