Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful 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.

Anonymous's avatar
Anonymous
Not applicable
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.