Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We finished May's financial data, but June is the end of the 2nd quarter. On my page, I have filtered to Year = "2019" and Month = "May". One of my columns is "Quarter Budget". I want this column, "Quarter Budget", to display the full 2nd quarter budget, not to be filtered down to just "May".
When I finish Septembers numbers and filter my report to just "September", I want this "Quarter Budget" column to display the full 3rd quarter budget.
Possible?
Solved! Go to Solution.
I figured it out. Change the (Dates[Quarter]) to Year, Month, Week.......... I need a column to show me the entire quarter total regardless if I have a slicer that is selecting only one month.
Total Projected Gross Profit QTR = CALCULATE([Total Projected Gross Profit], ALL(Dates),VALUES(Dates[Quarter]))
Looking for this identical solution. Let me know if you discover anything!
I figured it out. Change the (Dates[Quarter]) to Year, Month, Week.......... I need a column to show me the entire quarter total regardless if I have a slicer that is selecting only one month.
Total Projected Gross Profit QTR = CALCULATE([Total Projected Gross Profit], ALL(Dates),VALUES(Dates[Quarter]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |