Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am trying to set up a formula in DAX but not sure where to start. I have this on excel but need to translate this to DAX format for powerbi.
So a bit of background. I am trying to understand the percentage completion for a current project. For example the team have to go from 6000 (baeline) to 1150 (Target) for them to completed the acitvity. Therefore when the team hit 1150 they wouldve completed 100%. So i did an interpolation formula on excel as i wasnt sure how to do this on DAX.
The formula is (-100(Current No - Target No)/(Baseline-Target No))+100.
Can someone help me.
RU
Hi @Anonymous ,
you can make a new measure with the following DAX
Completion % = -100 * DIVIDE(Current No - Target No,Baseline-Target No,0) + 100
Regards,
Aditya
A better way to write the formula would be
Completion % = 100(1- DIVIDE(Current No - Target No,Baseline-Target No,0))
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |