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.

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.