Forum Discussion
Current Fiscal Week Calculation
Hi SHOOKANSON ,
Please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SHOOKANSON ,
Please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply. I actually ended up coming up with a solution after brainstorming with my coworker. I ended up using CALCULATE() to sum the fiscal week and filter on today's date. Not sure it's the best method but it seems to be working! I think I was having an issue with my data types as well. I appreciate the response though!
