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

Suppose in my table Date From 01-04-2016 to 25-05-2018

 

i Want to pickup only Max_date to before 4 month ago not current date..Only Max date exixt in table.

For this max date i made a variable  Max_Date=List.Max(Table[Sale])  Which is 25-05-2018

I created same 4 month..But i want to filter data in above two variable how 

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.