Forum Discussion
Conflicting Month Calculations
Here's my sample data, I have been creating some calculated columns that all look at the Date_Time field and determine it's academic year - I am trying to extend this to enable drill down on a monthl...
So I couldn't see the woods for the trees - the reason the final statement didn't work is because I didn't need to use the month function here.
This:
& FORMAT(MONTH('Views and Created'[Date_Time]),"MMM")
Should be:
& FORMAT('Views and Created'[Date_Time],"MMM")
So I couldn't see the woods for the trees - the reason the final statement didn't work is because I didn't need to use the month function here.
This:
& FORMAT(MONTH('Views and Created'[Date_Time]),"MMM")
Should be:
& FORMAT('Views and Created'[Date_Time],"MMM")