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.
I have two fields employees and Year. I am using this formula to calculate growth rate.
Growth % = divide (sum(Data[EMPLOYEES]) - calculate(sum(Data[EMPLOYEES]),SAMEPERIODLASTYEAR(Data[YEAR])), calculate(sum(Data[EMPLOYEES]),SAMEPERIODLASTYEAR(Data[YEAR])))
I am using sum because i have other fields which slices the employment data.
This gives error because Year is not date field. In "Modeling" tab, if i set the format to date then all the values become 1905. I understand its converting year 2013 to number which excel understands but is there is a easier way to fix this?
I assume there has to be easier way to convert year values to date that PBI can use for calculations like this.
Solved! Go to Solution.
You can use the below method to convert your year to date.
Hopefully this will help.
You can use the below method to convert your year to date.
Hopefully this will help.
Thanks Habib.. it worked..
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |