cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 !!
1 REPLY 1
Super User
Super User

Re: Calculating Sum

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


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

Proud to be a Datanaut!