cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baxter2_nois102
Frequent Visitor

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:

 

baxter2_nois102_0-1628548960414.png

if I revome the distinct I get this: 

baxter2_nois102_1-1628549007877.png

 

so the only funtion is getting the unique values by bank by date

any suggestion?

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @baxter2_nois102 ;

You could group by in power query ,or create a new table by dax.

Method1.group by in power query.

vyalanwumsft_0-1628736910581.pngvyalanwumsft_1-1628736940266.png

Method 2:create a dax table.

new table = SUMMARIZE('Table',[DescripcionBancos],[TasalnteresAplicable])

The final output is shown below:

vyalanwumsft_2-1628737147527.png

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.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @baxter2_nois102 ;

You could group by in power query ,or create a new table by dax.

Method1.group by in power query.

vyalanwumsft_0-1628736910581.pngvyalanwumsft_1-1628736940266.png

Method 2:create a dax table.

new table = SUMMARIZE('Table',[DescripcionBancos],[TasalnteresAplicable])

The final output is shown below:

vyalanwumsft_2-1628737147527.png

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.

View solution in original post

AllisonKennedy
Super User
Super User

@baxter2_nois102 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 


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!