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.
Dear power BI community, I would really appreciate If you could help me out with the following issue
I have a table which contains the following variable.
Company Year Quarter value 1 value 2
Company 1 2010 Q1 123 123
Company 1 2010 Q2 123 123
Company 1 2010 Q3 123 123
Company 1 2010 Q4 123 123
Company 1 2011 Q1 123 123
.
.
so on
Now I want to create a new column (using custom column) with formula:
= current year/ previous year
i.e. for 2011 Q1 it will be:
= (2011 Q1 value1)/ (2010 Q1 value1)
Any ideas, how to do this on M language?
Any help will be much appreciated.
Thanks
Solved! Go to Solution.
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.