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
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.