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

Hi tamerj1 

 

The MINX function is not supported either.

 

Unfortunately I still seem to be stuck.

 

Thanks for your help!

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.