Measure in Power Query Date

[cristianml]

Hi,

I'm trying to replicate a measure that I have in Power BI to Power query.  Is the same measure but for some reason it gives me an error:

This is the measure:

MTD Actual = CALCULATE([Actual], // Sum Amount
DATESBETWEEN('List Period'[Date], // Based on Dates Between
Date(YEAR(EDATE(today(),-1)),MONTH(EDATE(today(),-1)),1), // Date having Year = Today -1 Month / Month = today -1 Month, and Day = 1
EOMONTH(today(),-1))) // End Of Month effective today() -1 month

The only difference is in Power Bi my table of date is called 'List Period'[Date] and in Power Query is called Period Table.. But is the SAME table

Thanks,

[v-frfei-msft · Accepted solution]

Hi @cristianml ,

Please change the data type to date for the date column in your Period Table. Then the issue will be solved.