Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @Anonymous ,
Try like below:
Step1,change date type to date:
Step 2, use the following dax to create new date column:
datenew = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]),01)
Final you will see the below:
And you could use the new column and delete before column then rename new column .
Wish it is helpful for you!
Best Regards
Lucien
Hi @Anonymous ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @Anonymous ,
Try like below:
Step1,change date type to date:
Step 2, use the following dax to create new date column:
datenew = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]),01)
Final you will see the below:
And you could use the new column and delete before column then rename new column .
Wish it is helpful for you!
Best Regards
Lucien
Thank you for your help
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |