Forum Discussion

san17680's avatar
san17680
Icon for Helper II rankHelper II
3 years ago
Solved

DatesQTD 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.  QTD sales = CALCULATE('SAMPLE SUPERSTORE SALES DB'[total_sales],DATE...
General Comment
san17680's avatar
san17680
Icon for Helper II rankHelper II
3 years ago

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's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago
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's avatar
    san17680
    Icon for Helper II rankHelper II
    3 years ago

    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's avatar
      Mahesh0016
      Icon for Super User rankSuper User
      3 years ago

      san17680  See below Screen Shot it is give correct answer.

       

      • san17680's avatar
        san17680
        Icon for Helper II rankHelper II
        3 years ago

        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's avatar
      Mahesh0016
      Icon for Super User rankSuper User
      3 years ago

      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.