Forum Discussion
sunilvs24
8 years agoFrequent 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 !!
1 Reply
- Greg_DecklerCommunity Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490