Forum Discussion
DAX Logic
Hi all, just trying to figure out this DAX logic, any help is welcome.
Background: This is actuals and forecast data. The FY ends on month 6. I already have the FY year/month calculations in my Calendar dim. I'm trying to figure out the remaining figures when actuals are empty.
Task: For example, if the current month is P10 (which is March in this case) then I like to sum the following
Actuals P1+P2+P3+P4+P5+P6+P7+P8+P9+P10 + Forecast P11 + P12
Thanks in advance.
In your case, you can just create a custom calendar:
Create a Custom Period Calendar in Power Query - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
In your case, you can just create a custom calendar:
Create a Custom Period Calendar in Power Query - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.