DAX: calculate Average from start of the month to current date which is selected from dropdown

[Anonymous]

Hi All,

I have a table wherein we have scrore over all the days, And i have created a datedim table which has date, year, month number and all, If i select a date from dropdown the output should be average scrore from start of that month selected to current date which is selected from drop down. 

FYI, The table has many year records from 2017 to 2019. Could you please help me on this.

Thanks in Advance:
Nishanth

[yelsherif · Accepted solution]

You can use the date table with a date slicer, so you can select the required date. assuming the date column is 'DateTable'[date], then you can create a separate measure to estimate the month to date value

MTDValue =
VAR selectedDate = SELECTEDVALUE('DateTable'[date])

VAR DateStart = DATE(YEAR(selectedDate), MONTH(selectedDate), 1)

RETURN

CALCULATE(SUM(myTable[Value]), myTable[date]>=DateStart, myTable[date]<=selectedDate)

[yelsherif]

Sorry, you can use AVERAGE instead of SUM in the last calculation