Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
Hi @Anonymous,
Would you be able to provide some sample data to illustrate what you're trying to do?
Much appreciated
Alex
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
Hi there,
Below is the expected output.
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
Thank you very much Dale, it worked.
The calculation was just a make up numbers.
Regards
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |