data Modelling

[raju8004]

i have date column in sharepoint csv file and i have created date table by using calender(min(date column),today()) to establish a relationship berween tables to create a dynamic date range for slicer filter ,unfortunantely its not working and giving blank results.

can anyone help me to resolve

[Alex87]

create the date table in Power Query, see code here - Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum

Make sure you have the same data type for the two columns used for the relationship.

[raju8004]

DateTable1 =

ADDCOLUMNS (

    CALENDAR (MIN('CR Monitoring'[sys_created_on]), TODAY()),

    "Year", YEAR([Date]),

    "MonthNumber", MONTH([Date]),

    "MonthName", FORMAT([Date], "MMMM"),

    "Quarter", "Q" & FORMAT(QUARTER([Date]), "0"),

    "YearMonth", FORMAT([Date], "YYYYMM"),

    "YearMonthName", FORMAT([Date], "YYYY MMMM"),

    "Day", DAY([Date]),

    "Weekday", WEEKDAY([Date], 2),

    "WeekdayName", FORMAT([Date], "dddd")

)

created date table using above code

[raju8004]

both table dates are same format  i have made forgot to mention but not 

working