Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I created this column:
SubscriptionStartMonth = MONTH('Table'[SubscriptionStartDate]) & YEAR('Table'[SubscriptionStartDate]) because I want to filter to specific month on the matrix...but the column was created as Text, so I changed to the March 2001 format, but then I got this error:
SubscriptionStartDate comes as a Date format already.
I searched for and found this thread - https://community.powerbi.com/t5/Desktop/changing-date-format-from-text-to-date/m-p/2637027#M926429 ...
hanks.
Possible a locale issue? (as in one of your dates might be in mm/dd/yyyy rather than dd/mm/yyyy). Or that the date format isn't the one that PowerBI expects
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |