Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | ||
July | August | September | October | November | December | January | February | March | April | May | June | Totals | |
A | 52 | 52 | 27 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 401 |
A1 | 16 | 16 | 9 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 131 |
A2 | 16 | 16 | 9 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 131 |
A3 | 20 | 20 | 9 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 139 |
Is this what you are looking for?
you need to create a new measure and refer to your measure
https://1drv.ms/u/s!AiUZ0Ws7G26Rh0qcF1eO3MsAIeB1?e=nH0sOm
Thanks @Ahmedx , I tried this using my original data. It returns everything as 0. Would you happen to know the cause for it?
I don't know, maybe it's because of the connection in the model, or the filter action. need to see your file
what dates do you want to exclude here, I don’t understand something, this measure gives empty
The measure should calculate the year-to-date sum from the selected financial year up to the selected month from that financial year.
E.g. Slicer selection is 2023 and August. Then, it should return July-22 and Aug-22 sum. Hope that makes sense.
"E.g. Slicer selection is 2023 and August. Then, it should return July-22 and Aug-22 sum. Hope that makes sense."
it's only two months 😞
you didn't do it right
think again and write logic
you get in a slicer for example 2022.11
convert it to a date then write greater than or equal to this date and at the same time less than or equal to this date
Hi,
Share some data, explain the question and show the expected result.
Hi,
Share the download link of the PBI file.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |