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
Kp-8500's avatar
Kp-8500
Frequent Visitor
2 years ago

Hi Anonymous 
Actually, I am not clear. My context is when we work with the desktop, we can create a date table. If we directly work with the data engneering in fabric semantic layer, we cannot create a date table. In that case, how do we handle the time intelligence functions in the model?

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