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 dateany suggestion?
Go to Solution.
Hi, @baxter2_nois102 ;
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 WuIf 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
@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
Check out my Tokyo 2020 report with live stats - KUDOS much appreciatedHas 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
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.