Forum Discussion

panipat1990's avatar
panipat1990
Helper 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
Helper III
8 years ago

I want to filter data from max date to last 4 month data..

 

panipat1990's avatar
panipat1990
Helper 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
    Helper III
    8 years ago

    This type of error is coming

     

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

    • panipat1990's avatar
      panipat1990
      Helper 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
        Helper 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