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.
Dear all,
For my project I need to have the filter for the Year to Half year that is then the half year runing total, like the TotalMTD, TotalQTD & TotalYTD. However, when I am using the TotalMTD, TotalQTD or TotalYTD, by default it will show me, in the Line and Stack Column Chart, only the value of the highest selected year, when I am using only the month in the in the chart. With this Year to Half Year however, it's gives the summarized value for all selected years.
Can anyone please help me, that this will work the same way as the TotalMTD, TotalQTD & TotalYTD, so it will then also only show the value of the highest selected year?
The formula that I got from ExcellsFun (YouTube) is;
Hello Mahesh0016,
Thanks for the formula, but this doesn't change it, it is still showing the total of all selected years and I want to have to show only the highest selected year.
Regards,
Hans
Hi @Invisibleman ,
I couldn't find [Test Revenue Half Year to Date] in your sample. I think you also can try code as below.
Test Revenue Half Year to Date =
IF (
ISFILTERED ( mapCalendar[Month] ),
CALCULATE (
[Revenue (Base) (Selection EUR or USD)],
FILTER (
ALL ( mapCalendar ),
MapCalendar[Date] <= MAXX ( ALLSELECTED ( mapCalendar ), mapCalendar[Date] )
),
VALUES ( mapCalendar[Year Part] )
)
)
If this reply still couldn't help you solve your issue please share a sample with the measure you created and show me a screenshot with the result you want. This will make it easier for me to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Rico,
Sorry, but this formula is showing the total of the half year and not the highest selected year and then the total per month, like it also does with the MTD, QTD & YTD.
Also I am sorry, but it seems I had a link to the wrong file here's the correct file Correct file for Half Year to date
The measure I am using is;
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |