Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is it possible to create a measure that would return today's date in YYYYMMDD format but as a whole number? So today's date (May 18th 2020) would return as 20200518 but as a number.
Solved! Go to Solution.
Hi @Anonymous
Column = VALUE(FORMAT(TODAY(), "YYYYMMDD"))
@Anonymous , try like
Column = FORMAT(TODAY(), "YYYYMMDD")*1
Even if you create it like
Column = FORMAT(TODAY(), "YYYYMMDD")
You can change data type as whole number
Hi @Anonymous
Column = VALUE(FORMAT(TODAY(), "YYYYMMDD"))
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |