Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help with Line Chart Aggregation Issue: Two DAX Measures Result in Enormous Values

Hello all, I have the table displayed below which represents the data I want to show on a line graph, the desired outcome is to have two lines, one for the current rolling 12 months, and another f...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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