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.
Solved! Go to Solution.
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?
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.