Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
87 | |
68 | |
66 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |