How to make DAX fomula

[KotaroNoguchi]

I created the following DAX code.
But can't be completed.
Error indication "reached the end of input".
What's the problem?

-----------------------------------------------------------------------

rikei =

VAR CurrentDate = SELECTEDVALUE('Table'[Date])

VAR CurrentShot = SELECTEDVALUE('Table'[Shot])

VAR FilteredTable =

    FILTER(

        ALL('Table'),

        'Table'[Sensor] = "XXX" &&

        'Table'[Date] = CurrentDate &&

        'Table'[Shot] = CurrentShot &&

        'Table'[Value] > 20

    )

VAR FirstExceedingRow =

    TOPN(

        1,

        FilteredTable,

        'Table'[Time[s]],

        ASC

    )

VAR ResultTime =

    MINX(

        FirstExceedingRow,

        'Table'[Time[s]]

    )

RETURN

    IF(

        ISBLANK(ResultTime),

        BLANK(),

        ResultTime + 10

    )
-----------------------------------------------------------------------

[Anonymous · Accepted solution]

Hi @KotaroNoguchi ,

As @gmsamborn  said, I think you can change the column name of the Time[s] column.

I create a table as you mentioned.

Then I use the DAX code below and it gives me the same error message.

One way is that you can apply the content of the tips it gives.

Another way is that you can change the name of your column.

Best Regards

Yilong Zhou

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

[gmsamborn]

Hi @KotaroNoguchi 

The problem seems to be with your column name "Time[s]".  If you substitute [ and ] with ( and ) in your column name, then daxformatter.com will format it.

ie. Replace    'Table'[Time[s]]   with    'Table'[Time(s)]

Let me know if you have any questions.