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 everyone,
First of all thanks for reading me.
The problem is that I have calculated a table using dax (combining, joining and using lookupvalue and related with several tables) and now I need to send it back to power query in order to make a step with the calculated table. The step is to split de rows depending on the number of days (difference between start and end).
I think the only option is to use excel to obtain data from powerbi, create a dinamic table and in other page of the same sheet create a table that uses the values of the dinamic table, and then obain data from that excel.
Do you think there is any better opcion?
Thank you in advance.
PS: I would mark as solve with the best answer.
Solved! Go to Solution.
@CarmeloSanchez , In power query you can use merge
Lookup in power query
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@CarmeloSanchez , In power query you can use merge
Lookup in power query
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |