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 ,

We have a response from internal team -

" You could use an approach like this Build a Reusable Calendar Table with Power Query ⚡ - Excelerator BI. The advantage in Fabric with Direct Lake is that you can build this date table once then just short cut it into any model meaning you don't have to create duplicate date tables in every model "

Hope this is helpful. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Kp-8500 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Kp-8500 ,

    We haven’t heard from you on the last response and was just checking back to see if your query was answered.
    Otherwise, will respond back with the more details and we will try to help .

    Thanks