Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Team,
I have a table that looks like this. I have the number "11" which must be related to September 2020 and all other continuous numbers must continue the date sequence automatically. Can't come up with a variable. Please help.
Solved! Go to Solution.
@Anonymous , Create a column like
format(eomonth(date(2019,10,1),[Number]), "mmmm-yyyy")
@Anonymous , Create a column like
format(eomonth(date(2019,10,1),[Number]), "mmmm-yyyy")
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |