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!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.