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 revome the distinct I get this:
so the only funtion is getting the unique values by bank by date
any suggestion?
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.
2 Replies
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
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.
