Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! 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 Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@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
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |