Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DAX Formula

CurrentMonthAverageYield = VAR CurrentDate = MAX('calender yield'[Date]) RETURN CALCULATE(     AVERAGE('Production orders'[Qty in kg]),     FILTER(         'calender yield',         'calende...
  • Dangar332's avatar
    Dangar332
    1 year ago

    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 
    )
)

     

Dangar332's avatar
Dangar332
Resident Rockstar
1 year ago

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 
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you so much!!!