Forum Discussion
Computing Overdue based on filtered dates
Hi jmcph ,
You may change your formula like DAX below, which use the ALLSELECTED function to take effect of slicer filter, do the same with measure [MatDate] to replace ALL function.
Overdue=Sumx(ALLSELECTED(Masterlist), if…)In addition, you may create Calendar table , and use it in your formula which need to use time intelligence. For example, you may use " DATEADD(Calendar[Date], 60, DAY) " instead of " Masterlist[Date]+60"
Calendar= CALENDARAUTO()Or could you share some data sample and expected output? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jmcph ,
You may change your formula like DAX below, which use the ALLSELECTED function to take effect of slicer filter, do the same with measure [MatDate] to replace ALL function.
Overdue=Sumx(ALLSELECTED(Masterlist), if…)
In addition, you may create Calendar table , and use it in your formula which need to use time intelligence. For example, you may use " DATEADD(Calendar[Date], 60, DAY) " instead of " Masterlist[Date]+60"
Calendar= CALENDARAUTO()
Or could you share some data sample and expected output? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It actually solved my problem. Thank you very much!