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

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 

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

        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.