Forum Discussion
Profisee Calculated Column
How can I create a calculated column in Profisee called [Day] that displays the weekday name from the existing [Date] column?
My Profisee entity has a [Date] column with dates, and I want the [Day] column to show the corresponding weekday name (e.g., 'Monday', 'Tuesday', etc.).
I tried using FORMAT([Date], 'dddd') in the Expression Editor but received an error.
Hi DanSago ,
Thank you for reaching out to Microsoft Fabric Community.
As this is microsoft fabrics forum, i twould suggest raising a ticket in Profisee forum https://support.profisee.com/
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
7 Replies
Hi DanSago ,
Thank you for reaching out to Microsoft Fabric Community.
As this is microsoft fabrics forum, i twould suggest raising a ticket in Profisee forum https://support.profisee.com/
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
FORMAT([Date], "dddd") use double quote instead of single quote it will work.
Unfortunately the same error is raised when using double quotes instead of single quotes in Profisee.
I tried it in Power BI by additional column and it worked as expected no issue for me.
give it a try
WEEKDAY([Date], 2)
Same result
