Forum Discussion
Unique values
Hi guys! I am working on a QlikView migration to PBI, in QV I have this expression that I need to translate to PBI: only(tasainteres) it is basically getting this distinct: if I rev...
Hi, Anonymous ;
You could group by in power query ,or create a new table by dax.
Method1.group by in power query.
Method 2:create a dax table.
new table = SUMMARIZE('Table',[DescripcionBancos],[TasalnteresAplicable])The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Power BI visuals will automatically group by DescripcionBancos if you use it in a table visual, so you might not need the distinct in your query. If you are connecting direct to SQL you also have the option to paste the T-SQL statement in the advanced editor part of the import data: https://docs.microsoft.com/en-us/power-query/connectors/sqlserver#connect-using-advanced-options