DatesQTD not working

[san17680]

hi 

I am new to power BI.

I am just tyring to to do a running totals on quarters for different years. I am using QTD formula. 

QTD sales = CALCULATE('SAMPLE SUPERSTORE SALES DB'[total_sales],DATESQTD(Dates_[Date]))

The output somehow is not reflecting Running totals by quarters. 

Please review.

Thanks

[Mahesh0016]

Hii @san17680 Please share your ENDOUTPUT in table instead of graph for better understanding.THANK YOU!!

[san17680]

not sure what you mean by endoutput? you mean excel table?

output is going to be same as we discussed, its just that i am not able to translate the data into desired graph.

Thanks

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[san17680]

Hi

Thanks for your response, I had almost given up on expecting a response, cuz this is my first query on this forum.

I have attached my file here. THis is google drive link, hope you can access it.

https://drive.google.com/file/d/11qLQlRl92JdYzxZrLlNWByMLN6xJW5Co/view?usp=drive_link

let me rephrase my query. I would like to have separate lines for each quarter year. it works fine for the years YEARLY RUNNIN SALES tab in the attached file. 

I attempted to do the same in QTD SALES GRAPH NOT WORKING tab but to no avail. In short I would like to replicate the YEARLY RUNNIN SALES tab except I need quarters here (as separate lines) not years

Thank you for your time.

[Mahesh0016]

@san17680 I hope this helps you!THANK YOU!!

Use this measure in Y - axis
Total QTD Sales =

TOTALQTD([total_sales],'Calendar'[Date].[Date])

and calendar date table Mark as Date table >> right click on table >> select calendar date >>set as date >> see below screen shot

[san17680]

Thank you Mahesh for looking into this, however this is not what I am after. I am trying to replicate the graph as shown in the image. I need running quarterly sales  for each line. each line denotes a different quarter. eg (one line for current quarter, one for previous quarter current year, another for current quarter last year.  I was able to create this chart by years but stuck with quarterly approach. Thank you. 

[Mahesh0016]

@san17680 i think you should remove legend for In short I would like to replicate the YEARLY RUNNIN SALES tab except I need quarters here (as separate lines) not years.

[Mahesh0016]

@san17680  See below Screen Shot it is give correct answer.

[san17680]

How Do i show these quarters as separate lines in the graph as shown in the image I shared in the previous post? this is where I am struggling.

Thanks 

[Mahesh0016 · Accepted solution]

@san17680 

[san17680]

this does the trick. thank you so much Mahesh. I have marked this as solution. Just one last thing is there a way to fit ths graph so that I dont have to scroll all the way to right.