Forum Discussion
Anonymous
7 years agoNot applicable
A little help with DAX to PowerQuery
Hi!
I have a new table in DAX:
PTA =
SELECTCOLUMNS (
FILTER (
DVENDAS; [Tipo Venda]="PTA" && [Status]="VENDIDO" && [Tipo]="NORMAL");
"Bilhete"; DVENDAS[Bilhete];
"Agência"; DVENDAS[Agência];
"Bilheteiro"; DVENDAS[Logins.nome];
"Data da compra"; DVENDAS[Data MD];
"Linha"; DVENDAS[Linha];
"Origem"; DVENDAS[Origem];
"Destino"; DVENDAS[Destino];
"Hora"; DVENDAS[Hora];
"Serviço"; DVENDAS[Serviço];
"Passageiro"; DVENDAS[Passageiro];
"Data do serviço"; DVENDAS[Data Servi.];
"Valor cobrado"; DVENDAS[Vlr.Cobrado];
"Poltrona"; DVENDAS[Poltrona];
"Empresa"; DVENDAS[Empresa];
"Documento"; DVENDAS[Doc])But this table is huge and I would like to get this in Query Editor. How?
I have this:
= Table.SelectColumns(DVENDAS,{"Column1", "Column2", "...", "ColumnN"})
But how can I filter in Query like FILTER ( DVENDAS; [Tipo Venda]="PTA" && [Status]="VENDIDO" && [Tipo]="NORMAL")?
Why don't you just apply a filter in Power Query Editor on those 3 columns (clicking on the dropdown button besides each column) in the table DEVENDAS?
2 Replies
- AkhilAshok
Solution Sage
Why don't you just apply a filter in Power Query Editor on those 3 columns (clicking on the dropdown button besides each column) in the table DEVENDAS?
- v-chuncz-msft
Community Support