Forum Discussion
Need Help with Line Chart Aggregation Issue: Two DAX Measures Result in Enormous Values
Hi Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1)My test data is the same as yours.
(2) We can create two measures.
Rolling ddep current 12 month =
CALCULATE (
SUM ( AMD[Ddep] ),
DATESBETWEEN (
'Calendrier'[Date],
EDATE ( MIN ( 'Calendrier'[Date] ), -11 ),
MAX ( 'Calendrier'[Date] )
)
)
Rolling ddep for previous 12 months =
CALCULATE (
SUM ( 'AMD'[Ddep] ),
DATESBETWEEN (
'Calendrier'[Date],
EDATE ( MIN ( 'Calendrier'[Date] ), -23 ),
EDATE ( MAX ( 'Calendrier'[Date] ), -12 )
)
)
(3) Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply Anonymous , I will test and revert back to you. It seems like your results still shows big numbers, and I simply wanna show DDep values. I will share with you a simplied BI file too.
Hello Anonymous , sorry the late response, I tested many times but still getting the undersider result please find below the link for the Power BI file related to this issue: https://drive.google.com/file/d/1-u6GF_cygXVfBhzMIRmdOVlZWlfk-_Xt/view?usp=share_link
This is an example of the desired outcome:
Hi Anonymous ,
Please try:
AAAM_Current_R12M = CALCULATE(SUM('Sales deployed per full month'[Sales Deployed]),FILTER(ALL(DateTable),[Date]>=EOMONTH(MAX('DateTable'[Date]),-11)&&[Date]<=EOMONTH(MAX('DateTable'[Date]),0)))AAAM_Prior_R12M = CALCULATE(SUM('Sales deployed per full month'[Sales Deployed]),FILTER(ALL(DateTable),[Date]>=EOMONTH(MAX('DateTable'[Date]),-23)&&[Date]<=EOMONTH(MAX('DateTable'[Date]),-11)))Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello Anonymous , unfortunately that is not the correct output graph I want. this is what the end results should look like, which I solved recently:
Now I just need to be able to sort by Month and Year in this format April 2022, etc. which I can't figure out yet. Any help is much appreciated. this is the file Google Drive, Power BI file used