Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Calculating Percentage Change

Hi there, 

 

Does anybody know how to calculate percentage change with text based field e,g (FY17/18, 17/18) ?

 

I have a field that is a text, and am trying to calculate % change based on it. 

1 ACCEPTED SOLUTION

Hi @Anonymous,

 

If you can't use a date table, I would suggest you add a new table like below.

FY               Index

17/18           1

18/19           2

Then establish relationship. You can get the previous FY easily now.

How can we calculate the % Change? Your sample seems wrong.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
alexei7
Continued Contributor
Continued Contributor

Hi @Anonymous,

 

Would you be able to provide some sample data to illustrate what you're trying to do?

 

Much appreciated

Alex

Anonymous
Not applicable

Sample.PNG

 

Hi Alex, 

 

The sample data is above. I am trying to calculate % change using FY field

Can you add the % value you are expecting to see

Anonymous
Not applicable

Hi there, 

 

Below is the expected output.

 

Sample.PNG

Hi @Anonymous,

 

If you can't use a date table, I would suggest you add a new table like below.

FY               Index

17/18           1

18/19           2

Then establish relationship. You can get the previous FY easily now.

How can we calculate the % Change? Your sample seems wrong.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thank you very much Dale, it worked.

 

The calculation was just a make up numbers.

 

Regards

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.