Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculate function and direct

Hi all,   I'm trying to recreate a report. Right now I've made it with imported data from SQL but the new report is set to use Direct Query.   Previously I requested a solution for this issue: ht...
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 
Please try

Earleist Start =
SELECTCOLUMNS (
    SUMMARIZE (
        FILTER (
            ALL ( 'Table2' ),
            'Table2'[Timestamp Code] = "Start"
                && 'Table2'[Prod No] = SELECTEDVALUE ( 'Table2'[Prod No] )
        ),
        'Table2'[Prod No],
        "@TimeStamp", MIN ( 'Table2'[Timestamp] )
    ),
    "@@TimeStamp", [@TimeStamp]
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

tamerj1 

 

It seems that a lot of functions won't work with Direct Query. SELECTCOLUMNS isn't working either.