Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hello Everyone,
please could you help me, as i am preparing a new power Bi model where i am creating a calender table.
in that i have to mention "ISO date" COLUMN, please can you advise or show , i mean what is the calculation to get the ISO date , i thought this will not be a challenge but it is a tricky one.
Solved! Go to Solution.
@sandee Do you like this in DAX?
Column = FORMAT([Column1],"yyyy-mm-dd")
@sandee Do you like this in DAX?
Column = FORMAT([Column1],"yyyy-mm-dd")
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 21 | |
| 18 | |
| 11 |
| User | Count |
|---|---|
| 56 | |
| 54 | |
| 43 | |
| 36 | |
| 34 |