cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
InterSimi Regular Visitor
Regular Visitor

Re: DAX assistance: reporting for current month in DAX

I think I have it now.......So, I removed the IF statement and logic

 

new Sum Values Measure = 
VAR ReportRunTime = 
    IF(
        HASONEVALUE('Global Report Date'[Metrics Date]),
        VALUES('Global Report Date'[Metrics Date])
	)
RETURN
            
        CALCULATE (
            SUM ( 'Global Report'[Rpt MRC USD] ),
            'Global Report'[Metric] = "Backlog",
            MONTH ( ReportRunTime ) = MONTH ( 'Global Report'[Forecast Date] ),
			YEAR( ReportRunTime ) = YEAR( 'Global Report'[Forecast Date] ),
            ALLSELECTED ( 'Global Report'),
            VALUES ( 'Global Report'[Metric] )
        )

and get the following returned, which is what I expected to see....Please let me know if I have done something fundementally silly, as this is a massive learning curve for me here Smiley Happy

 

dax 4.jpg