1

I am using SSAS Tabular 2019 and I have had no problem in loading my views or tables, but this time instead of loading a Date table from SQL Server I created my own Date table using custom M code, but it appears that the date table is being imported as an Expression and not as a table. Here is a screenshot:

enter image description here

Here is my M code:

let
    Source = ( StartDate as date, EndDate as date ) as table =>
    let
        DateTable = 
            let 
                StartDateNumber         = Number.From ( Date.StartOfYear ( StartDate ) ), 
                EndDateNumber           = Number.From ( Date.AddYears ( Date.EndOfYear ( EndDate ), 1 ) ),
                DateList                = { StartDateNumber..EndDateNumber },
                ToTable                 = Table.FromList ( DateList, Splitter.SplitByNothing() ),
                ToDateType              = Table.TransformColumnTypes ( ToTable, { "Column1", type date } ),
                RenameToDate            = Table.RenameColumns ( ToDateType, { "Column1", "Date" } ) 
            in 
                RenameToDate,

        // Day related fields are created here
        Day_Fields = 
            let
                Add_Day_Name            = Table.AddColumn ( DateTable, "Weekday Name", each Date.DayOfWeekName ( [Date] ), type text ),
                Add_Day_Number          = Table.AddColumn ( Add_Day_Name, "Weekday Number", each Date.DayOfWeek ( [Date] ), Int64.Type )
            in
                Add_Day_Number,

        // Month related fields are created here
        Month_Fields = 
            let
                Add_Month_Name          = Table.AddColumn ( Day_Fields, "Month Name", each Date.MonthName ( [Date] ), type text ),
                Add_Month_Number        = Table.AddColumn ( Add_Month_Name, "Month Number", each Date.Month ( [Date] ), Int64.Type ),
                Add_Month_Initials      = Table.AddColumn ( Add_Month_Number, "Month Initials", each Text.Start ( [Month Name], 3 ), type text )
            in
                Add_Month_Initials,

        // Year Related Fields are Create Here

        Year_Fields = 
            let
                Add_Year                = Table.AddColumn ( Month_Fields, "Calendar Year Number", each Date.Year ( [Date] ), Int64.Type ),
                Add_Year_Text           = Table.AddColumn ( Add_Year, "Calendar Year", each "CY " & Text.From ( Date.Year ( [Date] ) ), type text )
            in
                Add_Year_Text
    in
        Year_Fields
in
    Source

Can you please confirm what is happening here?

AntrikshSharma
  • 629
  • 1
  • 3
  • 12

0 Answers0