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
Hardik's avatar
Hardik
Continued 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
Helper 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
    Helper 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?

  • KDTV's avatar
    KDTV
    Regular Visitor
    6 years ago

    Hello,

     

    The same problem here. I would like to switch from Qlikview to Power BI but before I do this I need to find a solution to filter a table on two dates. In Qlikview I created a variable vKeyDate and if I select that variable via a calender widget it selects all row in the table where posting_date <= vKeyDate and payment_date > vKeydate. How can I do that in Power BI?

    Now I have to work with 2 filters in the front-end which is visually not sexy/dummy proof.

     

    Any help would be appreciated here.