Forum Discussion
Calculating Sum or Measurements
I have columns with Fiscal years, and Periods with Amounts for specific accounts. I want to be able to total up the latest Fiscal year and period for specific accounts. What would be the appropriat...
Hi Anonymous ,
You seem to want:
If so, please refer to this blog. Sample pbix files can be downloaded below the blog.
For specific accounts, you can put them into a slicer to filter them.
Month-related calculations – DAX Patterns
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum