Unique values

[Anonymous]

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?

[v-yalanwu-msft · Accepted solution]

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.

[AllisonKennedy]

@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