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.
I am attempting to create a paginated report that I can schedule to run on the 1st of every month without always putting in the date parameters. I am attempting to use a filter expression:
'beginning of month
=DateSerial(Year(DateAdd("m", -1, Today())), Month(DateAdd("m", -1, Today())),1)
'End of month
=DateSerial(Year(DateAdd("m", -1, Today())),Month(DateAdd("m", -1, Today())), Day(DateAdd("d", -1, DateSerial(Year(Today()), Month(Today()), 1)) ) )
But get the followin Error: The processing of FilterExpression for the dataset 'Filtered' cannot be performed. Cannot compare data of types System.DateTimeOffset and System.DateTime. Please check the data type returned by the FilterExpression.
Any ideas what I can do to fix this?
Hi @officeiq ,
According to the error message, the problem is caused by data format differences,refer the following and check if it is helpful:
https://stackoverflow.com/questions/4331189/datetime-vs-datetimeoffset
Best Regards
Lucien
Any idea how I could resolve this issue?
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.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
4 | |
3 |