Forum Discussion
benjellounm
5 years agoRegular Visitor
filter by group by
Hi Everyone, I need help creating a group by the table and use it to filter my data. The table has two columns; the name of the firm and Certification type and what I would like to do is create a tab...
- 5 years agoNew Table =ADDCOLUMNS (VALUES ( Data[Firm] ),"@Certification",CALCULATE(IF ({ "SBE" }IN VALUES ( Data[Certification] )&& { "DBE" } IN VALUES ( Data[Certification] ),"SBE-DBE",DISTINCT ( Data[Certification] ))))
- 5 years agoNew Table V2 =ADDCOLUMNS (SUMMARIZE(Data,Data[Firm],Data[Status]),"@Certification",CALCULATE(IF ({ "SBE" }IN VALUES ( Data[Certification] )&& { "DBE" } IN VALUES ( Data[Certification] ),"SBE-DBE",DISTINCT ( Data[Certification] ))))
Jihwan_Kim
5 years agoSuper User
New Table =
ADDCOLUMNS (
VALUES ( Data[Firm] ),
"@Certification",
CALCULATE(
IF (
{ "SBE" }
IN VALUES ( Data[Certification] )
&& { "DBE" } IN VALUES ( Data[Certification] ),
"SBE-DBE",
DISTINCT ( Data[Certification] )
)
)
)
benjellounm
5 years agoRegular Visitor
Thank you very much 😊