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

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...

      • Sibrulotte's avatar
        Sibrulotte
        Icon for Helper IV rankHelper IV
        6 years ago

        Poor panipat!

        no one came to the rescue and I have the same issue. Your Qlikview skills are not transferable to Power query easily my friend...

         

         

        I have the same question, how do you obtain the latest date in a series of values, and use that in as a parameter.

         

        For example, I'd want to filter out just the end of month dates, plus the latest date even if it is not the end of month.

        I created a column that has the end of month value, and I'm creating another conditionnal column that tests if these values are the same. But for the latest date that isn't an end of month, I want to know if it's the latest date in my series so I keep it.

         

        Any super bright ideas for that?