Forum Discussion
Display filtered data simultaneously in the same column
Hi, I have the following tables and slicers: But I would like the Commitments to displayed as follows. But then Actuals and a bunch of other stuff are incorrect. How can I...
Anonymous , if you want to filter a date twice, You need atleast one independent table to do that
refer: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi amitchandak,
Thanks!
So I treated actuals as current year and commitments as prior years and applied your solution, here are the resutls:
How can I edit your Dax for New Commitments, so instead of a min and max range, it selects the lastest report run date per period.
For example, right now when I manually select the lastest report run dates from Commitment.reprot run date, it treats it like the min and max and also incldues March 9th, which I don't want.