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
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 

Please try

Earleist Start =
MINX (
    FILTER (
        ALL ( 'Table2' ),
        'Table2'[Timestamp Code] = "Start"
            && 'Table2'[Prod No] = SELECTEDVALUE ( 'Table2'[Prod No] )
    ),
    'Table2'[Timestamp]
)
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
    Icon for Community Champion rankCommunity 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.