I have years data from 2019 Dec to Jan 2021 I have used below query but I am not getting 2021 in the report
I need help on the following dax Month Date = If(day([Date])<=10, eomonth([Date],-1), eomonth([Date],0))
from 2019 to 2020 is correct but I am not getting 2021
I can’t reproduce the error in my environment, the dax worked in my environment.Here is the output:
Could you provide your sample data?
I didn't see date colum in your screenshot. Do you have data that is bigger than 2021/1/10?
Proud to be a Super User!
Some how I am getting when i tried with a sample Data. Just check whether you have dates in 2021?
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.