Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is my data and I'm trying to fetch the day from this date like Monday, Tue, etc. So far I have tried this formula
OrderDay = FORMAT([Date], "dddd"). but it's not fetching the date column from the table and also tried writing the table name before [Date] but was unable to fetch that.
Solved! Go to Solution.
Try the below measure.
Month = FORMAT(SELECTEDVALUE('Calendar'[Date]),"DDDD")
Try the below measure.
Month = FORMAT(SELECTEDVALUE('Calendar'[Date]),"DDDD")
Create a date table. In your date table, create a new column, "Day." Use that same formula you have.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |