Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, someone shared this DAX code with me to create a Date_Calendar table in a PBI desktop file.
Can you help me modify the code to include "DayName" in the table, e.g. Monday, Tuesday, etc.
CODE:
Solved! Go to Solution.
Never mind. I got it. Instead of "MMMM" I changed to "dddd". Thank you!
Create below Column:
DayName = Format(Table[DateColumn],"dddd")
To get the full day name use = Format([Date], "dddd")
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat, is it possible to add it into the Date_Calendar DAX code instead?
I tried that, but when I put it in the Calendar, it says "Friday" for every day of the month, instead of "Friday", "Saturday", etc.
When I used a Table visual to bring that field in, all the day names of the week show up, but I don't know why in the calendar it doesn't, so I'm wondering if it's just easier to add to the Date_Calendar creation code?
Thanks.
Never mind. I got it. Instead of "MMMM" I changed to "dddd". Thank you!
I typed MMMM by accident. Posted and then came back to edit. You must have seen it by then.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hello, this code gave me the month, eg. "April". What would it be if I want the DAY NAME, e.g. Tuesday. Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |