Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have one column, only one column that has rejected and successful. Rejected is represented by 0 and successful is represented by 1. How can I calculate the percentage difference for rejected and successful separately?
@pro_x Can you share some sample data and expected out? That way people here can help you quickly.
Thanks
This is the data I have, rejected is represented by 0 and successful is represented by 1.
@pro_x , two measures likes
Mark all them as % column
successful =divide(calculate(countrows(Table),Table[col]=1),countrows(Table))
Rejected =divide(calculate(countrows(Table),Table[col]=0),countrows(Table))
percentage difference = [successful] -[Rejected]
Hi
Thank you,
How would i calculate the percentage change for Rejected?
Hi @pro_x ,
%Change will require your earlier period rejected Values.
You need to share sample data and expected output to get the correct solution.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi this is my sample data. Rejected is represented by 0and successful is represented by 1.
Hi @pro_x
% change is difference of old percentage vs new percenatage. Like Sales Last year vs This year
You need to share a good sample of data with the earlier dates,
One column cannot detemine %change when there is no context to that column.
Do you want difference between successful and reject.??
Regards,
Harsh Nathani
Yes, i want like sales last year vs this year.
e.g. rejected last year vs this year
I only have that column with another column for date
Yes you're right, so how would i go about extracting the earlier period for rejected. I only have one column that has rejected and successful. Should i create a conditional column to extract rejected. How would i extract the earlier period and do a %change?
Hi @pro_x
Your problem seems interesting, what do you mean % changes for successful and rejected seprately, changes on what basis?
Hi @mhossain
%change on earlier period for rejected and successful. I want a measure that shows the %change for rejected over a certain period and a measure that shows % change for successful over a certain period. I have a column that has rejected and successful in one column.
User | Count |
---|---|
51 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |