Forum Discussion

Kp-8500's avatar
Kp-8500
Frequent Visitor
2 years ago

How to create Calculate table on synapse Data Enginering in fabric

Hi,   I bring my tables to Synapse Data Engineering, and on top of it, I create a semantic layer. In that, I need to create a calculated table for my time intelligence functions. How do I create a ...
data engineering
lakehouse
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Kp-8500 ,

Thanks for using Fabric Community.  Apologies for the delay in reply from our side.

You can create calculated tables in Direct Lake models provided they do not reference other tables in the model ( so CALENDAR() should work, but CALENDARAUTO may not).

Hope this is helpful. Do let me know incase of further queries.