Showing results for 
Search instead for 
Did you mean: 
sunilvs24 Frequent Visitor
Frequent Visitor

Calculating Sum

Hi All, Any one please help me to understand, what might be wrong here. It is not showing up any error, but when i pull the measure on a card, value does not show up. M_CurrentWeek is a measure - Returning the value of the current week from a column in a table While performing a sum, i need it to be < = CurrentWeek, which is where i am not able to get through. On top of this i have 2 more conditions, which i will insert. Help me insert the measure value, which should be <= Below is the formula: M_Actuals_CurrentWeek = CALCULATE(sum(Waterfall_RS[value]),FILTER(Waterfall_RS,Waterfall_RS[Period_Week13]<=[M_CurrentWeek])) Thanks !!
Super User
Super User

Re: Calculating Sum

Please see this post regarding How to Get Your Question Answered Quickly:

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!