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.
We need to compare the budget figures and the actual revenue. In relation with this, we have the following problems:
- The budget is based on an interval monthly.
- The actual revenue is based on specific dates.
How can we compare the columns?
Additionally, we would like to make a column accumulating the budget figures. So we will be able to identify wether the budget is achieved or not.
Budget:
Revenue:
Solved! Go to Solution.
Hi @Anonymous,
To create a calculated column using the formula in Budget Table.
Column = var actual = CALCULATE(SUM(Revenue[Amount]),FILTER(ALL(Revenue),Revenue[Date]>=Budget[FromDate] && 'Revenue'[Date]<=Budget[ToDate])) return IF(ISBLANK(actual),BLANK(),IF(actual>='Budget'[AmountDefaultCurrency],"achieved","not achieved"))
For more details, please check the pbix as attched.
Regards,
Frank
Hi @Anonymous,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Hi @Anonymous,
To create a calculated column using the formula in Budget Table.
Column = var actual = CALCULATE(SUM(Revenue[Amount]),FILTER(ALL(Revenue),Revenue[Date]>=Budget[FromDate] && 'Revenue'[Date]<=Budget[ToDate])) return IF(ISBLANK(actual),BLANK(),IF(actual>='Budget'[AmountDefaultCurrency],"achieved","not achieved"))
For more details, please check the pbix as attched.
Regards,
Frank
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |