Forum Discussion

Ashwath_Bala_S's avatar
Ashwath_Bala_S
Helper II
2 years ago
Solved

How to create Calculated Tables

Hi,   In Power BI, we have the option of creating "Calculated Tables" (say for example, CALENDARAUTO() which we use to generate a date table based on the data loaded into the model).   (i) I have...
data engineering
Data Integration
data warehouse
Fundamentals
one lake
power bi
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Ashwath_Bala_S 

    (ii)  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)

    (iii) You cannot currently edit Direct Lake models in Desktop you need to use the Web Editor at this time.

    Hope this helps. Please let me know if you have any further questions.

Ashwath_Bala_S's avatar
Ashwath_Bala_S
Helper II
2 years ago

Hi Anonymous ,

 

Thanks for your reply and keeping me updated!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ashwath_Bala_S 

    (ii)  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)

    (iii) You cannot currently edit Direct Lake models in Desktop you need to use the Web Editor at this time.

    Hope this helps. Please let me know if you have any further questions.

    • Ashwath_Bala_S's avatar
      Ashwath_Bala_S
      Helper II
      2 years ago

      Hi Anonymous ,

       

      Yeah, it helps!

      Thank You!

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Ashwath_Bala_S 
        Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.