Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
Hi @cristianml ,
Please change the data type to date for the date column in your Period Table. Then the issue will be solved.
Hi @cristianml ,
Please change the data type to date for the date column in your Period Table. Then the issue will be solved.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.