Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help With IF Sum

Hi,   I am trying to recreate the following calculation into a DAX Measure. Please can someone advice how ths is possible:-       if  {Job_Mth}<={Current Month (Year Month YYYY-MMM Selection from...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi<

 

Thanks again.

 

Ok so i have a date in thefuture in my projmnth field. When we use MAX in the measure its taking this into consideration which i want to ignore.

 

Any proj months after the current period selected need to sum the contract amount anything less than or equal to the current period needs to sum proj dollars.

 

On the example below i wish to get the sum of proj dollars (12,210.130.00) the measure is returning the other value