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.