Forum Discussion
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...
Anonymous , If you have job_date it would much more easy
measure
= if(max(Table[Job Date]) <= eomonth(Today(),0) ,[Job Projected Pounds], [Job Contract Amount])