Forum Discussion
Helper IIDatesQTD not working
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.
The output somehow is not reflecting Running totals by quarters.
Please review.
Thanks
11 Replies
- lbendlin
Super User
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-Forum/ba-p/963216
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/1447523
san17680Hi
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.
- Mahesh0016san17680 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
- 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
