Forum Discussion

JakeJack's avatar
JakeJack
Frequent Visitor
4 years ago
Solved

Help with a Date Question

Hi all   My first post.   I'm a newbe to Power BI coming from database development and have been scratching my head for a few hours over what I reckoned should be something simple.   I've creat...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    JakeJack , use this inplace of today 

    var _today = max(allselected(DailyProd), DailyProd[pdate])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JakeJack 

MAX : Returns the largest value in a column, or the larger value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order.

MAXX : Returns the largest value that results from evaluating an expression for each row of a table. Strings are compared according to alphabetical order.

ALLSELECTED : Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

You can get a detail understanding through these links below .

https://docs.microsoft.com/en-us/dax/maxx-function-dax

https://docs.microsoft.com/en-us/dax/max-function-dax

https://docs.microsoft.com/en-us/dax/allselected-function-dax

 

Best Regard

Community Support Team _ Ailsa Tao