Forum Discussion

DogManX's avatar
DogManX
Frequent Visitor
8 years ago
Solved

Adjust Calculated Column based on filter applied to another table.

I have a date table (Sales_Totals) where I am calculating the cumulative sales for each day in the quarter pulling the sales numbers from the Sales_Info table based on the Sale Date. So it pulls the ...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi DogManX,

     

    The measures are based on context so depending on the information you have on your x-axis you are abble to have several points, If you have quarte only it will give one point, months it will give 3 points days it will give 90 points.

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi DogManX,

 

In this case you need to also add another measure for the previou year calculation something like:

 

Cumulative PY = TOTALQTD ( SUM ( Sales_Info[Sales] ); SAMEPERIODLASTYEAR ( Date_Table[Date] ) )

the both measures will be filter by context.

 

Regards,

MFelix

DogManX's avatar
DogManX
Frequent Visitor
8 years ago

But will I be able to have a line graph going through the course of the quarter using a measure? I thought I needed a column calculation for it to be more than a single data point?

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi DogManX,

     

    The measures are based on context so depending on the information you have on your x-axis you are abble to have several points, If you have quarte only it will give one point, months it will give 3 points days it will give 90 points.

     

     

    Regards,

    MFelix