Forum Discussion

panipat1990's avatar
panipat1990
Icon for Helper III rankHelper III
8 years ago

How to make max_date variable in query editator.

Dear Team,   i am new in ppower bi.I stuck a requirement. i used another bi tool.Where i made variable in backend. And used Below Written condition= Where Date=Date(Floor('$(vMax_Date)'),'DD/MM/Y...
Need Help
panipat1990's avatar
panipat1990
Icon for Helper III rankHelper III
8 years ago

This type of error is coming

 

Expression.Error: A cyclic reference was encountered during evaluation.

panipat1990's avatar
panipat1990
Icon for Helper III rankHelper III
8 years ago

SO NO ONE KOWN HOW TO MAKE DATE FILTER FROM MAX DATE TO BEFORE MAX DATE TO 4 MONTH EGO

  • panipat1990's avatar
    panipat1990
    Icon for Helper III rankHelper III
    8 years ago

    Dear Team,

     

    i made a variable of max date..When i filtered data in power editator then it create a error.Why this coming error..

    i asked same question many times but noone didnot give me proper answer

    • Hardik's avatar
      Hardik
      Icon for Continued Contributor rankContinued Contributor
      8 years ago

      Hi panipat1990,

      Not sure of the error you are getting, but you can use the below method to get the latest date data:

      Create a new column in your table and then filter data using that column value.

      • panipat1990's avatar
        panipat1990
        Icon for Helper III rankHelper III
        8 years ago

        Hi 

        I am not asking this.this is frontend funcationality..i asked Power Query for max date.

        i made a variable in power editator for max date..but this variable is not working for filtering data...