Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help in Query preparation- paginated report..

Hi All,

 

I am using below query to create a paginated report. 

When i run the query getting syntax error. Could you please provide some solution.

 

 

Thank you.

 

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Please share the query in text format with the error. Difficult to tell with image

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      amitchandak ,

       

      Please see the below query used in report along with error measage. (removed some columns here) 

       

      Define
      Var BeignDate=Cast('ContractData'[SNAPSHOT_BEGIN_DATE] as date)
      Var EndDate= Cast('ContractData'[SNAPSHOT_END_DATE] as Date)

      EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT],

      FILTER(VALUES('ContractData'[OVER 90]),'ContractData'[OVER 90]="YES"),
      RSCustomDaxFilter(@ContractDataCONAME,EqualToCondition,[ContractData].[CO_NAME],String),

      FILTER('ContractData', @Date>=BeignDate && @Date<=EndDate))

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        amitchandak  thank you so much for soultion. but the problem is in date conversion and last filter syntax. if i removed last filter line, query works fine. 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Try like

     

    Define
    Var BeignDate=Cast('ContractData'[SNAPSHOT_BEGIN_DATE] as date)
    Var EndDate= Cast('ContractData'[SNAPSHOT_END_DATE] as Date)

    EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT],

    FILTER(VALUES('ContractData'[OVER 90]),'ContractData'[OVER 90]="YES" && ContractData[CO_NAME] = @ContractDataCONAME),

    FILTER('ContractData', @Date>=BeignDate && @Date<=EndDate))