Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have fTE/month, for few month it has no value and for few it has value.
I have the data from 2016 jan till march 2018.
I need to calculate a measure where i need percentage calculation.
1-(FTE,Month / 4023)
when there is no value which is 0 then it will divide by 4023 and gives "0".
Later it is sub by 1 gives 100% percentage.
my concern here, i dont have values for my future data which is april 2018 and above but it is giving 100%.
Where i dont need my future data to be shown because it doest have any values(Not updated)
In this case how can i slove this issue.
Kindly suggest!
Thanks:)
Hi @Anonymous,
Can you share a sample please? The solution could be using function "IF".
Best Regards,
Dale
Hi @v-jiascu-msft,
Thanks for you effort,
Below is the screenshot of the data,
I have FTE for each month starting from Jan 2016 - April 2018, But when i upload it in power BI its giving the value for future month as well which is not updated at all.
Hi @Anonymous,
What's your formula? It could be something wrong with your formula.
Best Regards,
Dale
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |