Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello Everyone,
I have a created column
4/17/2023 4:19:06 AMI created another column and i want this column created to be a month and i used
Month = FORMAT(tbl[created], "MMM") but it did not change. Am i doing it incorrectly?
Thanks in advance for your help
Solved! Go to Solution.
Got it.
Month = FORMAT(DATEVALUE(tbl[created]), "MMM")
//DATEVALUE SOLVES IT
Got it.
Month = FORMAT(DATEVALUE(tbl[created]), "MMM")
//DATEVALUE SOLVES IT
| User | Count |
|---|---|
| 50 | |
| 40 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 87 | |
| 73 | |
| 37 | |
| 28 | |
| 26 |