Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |