How to replace blanks values in Date field with "-" seperator or NA

[rajendraongole1]

Hi All,

I have query on date field , where i am getting some blanks and want to replace it with "-" or NA.

IF (

    SELECTEDVALUE ( table[template] ) = "AC Template1",

    "Not Applicable",

    CALCULATE (

        SELECTEDVALUE ( table[actualdate] ),

        Reporting_dates[data_tranS] = "Imple Release"

            || Reporting_dates[data_transfer] = "Q1",

        GROUPBY ( Report_Project, Report_Project[pro_name] )

In the above measure, i am gettng blanks values and want to replace whereever the blanks with "-"

Please suggest.

Regards,

Rajendra

[Ahmedx]

let's say your measure, which was written above is called [Date my] then you need to write like this:

IF(ISBLANK([Date my]),"-",[Date my]&"")