Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.