Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

date 01-01-1

i am using survey table in my data model which has last_response_date column last_response_date has value '01-01-1900' for around 30 surveys i created calendar table using below expression by ignor...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, powerbiexpert22 

    Perhaps you need to sacrifice your computer's performance and create an entire date table.

    Date = 
    VAR MinDate = CALCULATE(MIN(survey[last_response_date]))
    VAR MaxDate = CALCULATE(MAX(survey[last_response_date]))
    RETURN
        CALENDAR(MinDate, MaxDate)

     

     And then create a calculated column or measure to filter out other values other than 1-1-1900.

    FilteredLastResponseDate = 
    IF(survey[last_response_date] = DATE(1900, 1, 1), BLANK(), survey[last_response_date])

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aduguid's avatar
aduguid
Icon for Memorable Member rankMemorable Member
2 years ago

You could update the value in Power Query to NULL, Blank or the minimum date you want in your table.