Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |