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.
Hello,
I am looking for a formula to calculate basis points instead of showing the year over year growth. I am not great with DAX so was hoping this would be an easy formula? Below is an example of what I have used the current KPI.
Hi @Anonymous ,
Could you pls provide some sample data with expected output?
@Anonymous Divide by 100,000? Right? One hundredth of one percent?
@Anonymous , what is basis points mean, diff ? Can you explain it?
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
diff = [YTD] - [Last YTD Sales ]
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |