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.
Hello,
I have tried to create a calculated column so that in that table I get values of percentage variation with respect to the previous month. As it is an example table and as you can see the months may not be consecutive, any idea? I have tried with this DAX but it gives me blank values.
Fecha Producto Precio GAP GAP Price variation
01-dic-23 SQL Server Enterprise 2 Corepack -1801999,84
01-dic-23 SQL Server Standard 2 Corepack 0,00
01-dic-23 WS Datacenter 16 Corepack -696000,40
01-dic-23 WS Standard 16 Corepack 0,00
01-abr-24 SQL Server Enterprise 2 Corepack -452501,94
01-abr-24 SQL Server Standard 2 Corepack -236042,40
01-abr-24 WS Datacenter 16 Corepack -584652,75
01-abr-24 WS Standard 16 Corepack 105433,30
Calculate column:
Solved! Go to Solution.
Hi again,
I have found the solution:
Hi @jemalosa
Can you provide us with a solution, so that others who are experiencing similar problems can also benefit from it.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi again,
I have found the solution:
Hello Jaylenly,
any ideas?
I thought I had the solution but it doesn't give me the correct data, can you help me?
This is the formula I used:
I thought I had the solution but it doesn't give me the correct data, can you help me?
This is the formula I used:
Resolved. Thank you
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
33 | |
27 | |
24 | |
23 |