The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi all,
I'm trying to create a cumulative graph that compares revenue at the same point of the year for each of our past financial years. On the X axis I have day of the year (which is actually day of the financial year e.g. 1st July = day 1). I've created the following measure with some help from online:
Solved! Go to Solution.
Use following measure according to your columns.
Cumulative From Start = CALCULATE(SUM(Orders[Total_Sale]), FILTER(ALL(Orders),Orders[Order_date ]
<=MAX(Orders[Order_date ] )),VALUES(Orders[YEAR]))
also you can use VALUES(Orders[MONTH]) instead of year if required.
Use following measure according to your columns.
Cumulative From Start = CALCULATE(SUM(Orders[Total_Sale]), FILTER(ALL(Orders),Orders[Order_date ]
<=MAX(Orders[Order_date ] )),VALUES(Orders[YEAR]))
also you can use VALUES(Orders[MONTH]) instead of year if required.
@Anonymous
Fantastic! This really helped me to work it out. Initially this didn't show what I wanted, however I have now changed the Order Date for 'Day of Year' in the measure and my X axis is now 'Month of Financial Year' which seems to have fixed it! Measure now reads:
@Anonymous ,
Generally, you may modify your measure using DAX below and check if it can meet your requirement.
Result = TOTALYTD ( SUM ( New_Merge[Actual_Rate] ), ALLSELECTED ( New_Merge ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |