topic Re: DAX Formula in DAX Commands and Tips

DAX Formula

Anonymous — Thu, 26 Sep 2024 12:30:39 GMT

CurrentMonthAverageYield =

VAR CurrentDate = MAX('calender yield'[Date])

RETURN

CALCULATE(

AVERAGE('Production orders'[Qty in kg]),

FILTER(

'calender yield',

'calender yield'[Date] >= STARTOFMONTH(TODAY()) &&

'calender yield'[Date] <= ENDOFMONTH(TODAY())

)

)
When I try to create this formula to show the current month average yield I get red lines under "TODAY" and an error message: "Parameter is not the correct type".

Re: DAX Formula

Dangar332 — Thu, 26 Sep 2024 12:39:35 GMT

Hi, Anonymous

You can't Pass scalar value to STARTOFMONTH function you need to provide column name
Try below measure

CurrentMonthAverageYield = VAR CurrentDate = MAX('calender yield'[Date]) var Monthstart = eomonth(today(),-1)+1 var MonthEnd = eomonth(today(),0) RETURN CALCULATE( AVERAGE('Production orders'[Qty in kg]), FILTER( 'calender yield', 'calender yield'[Date] >= Monthstart && 'calender yield'[Date] <= MonthEnd ) )

Re: DAX Formula

Anonymous — Thu, 26 Sep 2024 12:50:59 GMT

Thank you so much!!!