Profisee Calculated Column

[DanSago]

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.

[v-sathmakuri · Accepted solution]

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!!

[nilendraFabric]

give it a try

WEEKDAY([Date], 2)

[DanSago]

Same result

[DataGuru412]

FORMAT([Date], "dddd")  use double quote instead of single quote it will work.

[DanSago]

Unfortunately the same error is raised when using double quotes instead of single quotes in Profisee.

[DataGuru412]

I tried it in Power BI by additional column and it worked as expected no issue for me.

[DanSago]

What happens when you try it in Profisee?