Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have the few years Data from 2021 to 2025 . Every year have QTY month wise . i want find compund growth for month wise . i used below formula for Years in Excel . i want to convert to Month.
QTY Month year
10 Jan 2021
20 Feb 2021
30 Mar 2021
40 Apr 2021
21 Dec 2025
Looking for support .. thanks in advance
Go to Solution.
supposing you have a table like:
1) add a calculated column like:
MonthSN = ([Year]*12+[Month])
2) plot a slicer with a calculated table like:
3) plot a table visual with year and month column and a measure like:
VAR _currentmonthSN = MAX(data[MonthSN])
VAR _n = SELECTEDVALUE(n[n])
VAR rate =
IF(rate<>-1, rate, "")
it worked like:
View solution in original post
@FreemanZ Thank you so much . its working
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.