Forum Discussion
Circular dependency workaround for Formula
- 4 years ago
Auto_queen , You need to calculate
if other are columns
This Month's Commission Payable =
var _date = eomonth([Date], -1)
var _value =Sum([YTD Sales Payable]) - Sum([YTD Salary Paid])
return calculate( if(_value>0, _value,0) , Filter(Table, eomonth(Table[Date],0) =_date))
in case others are measure
calculate([YTD Sales Payable]- [YTD Salary Paid], previousmonth('Date'[Date]) ) //use date table
as columns
YTD Commission Paid =
var _date = eomonth([Date], -1)
var _value =Sum([YTD Sales Payable]) - Sum([YTD Salary Paid])
return calculate( Sum( if(_value>0, _value,0) ), Filter(Table, eomonth(Table[Date],0) <=_date))
- 4 years ago
Hi Auto_queen
Please refer to attched sample file. Your actual case might be littele different depending in your real data and data model.
Hi Auto_queen
Please refer to attched sample file. Your actual case might be littele different depending in your real data and data model.
Thank you for your help! The YTD Commission Paid wasn't populated, but I made a slight adjustment and it worked!