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])
amitchandak's avatar
amitchandak
Super User
4 years ago

JakeJack , use this inplace of today 

var _today = max(allselected(DailyProd), DailyProd[pdate])
JakeJack's avatar
JakeJack
Frequent Visitor
4 years ago

Hi amitchandak

 max(allselected(DailyProd), DailyProd[pdate]) 

didn't work but maxx(allselected(DailyProd), DailyProd[pdate]) did!

 

I'm not sure as to why I need to use allselected eg if I create a measure Max Prod Date = calculate(max(DailyProd[pdate]),DailyProd[day_sales]>0) and place this measure on a page I do get the maxium production date. So I've no idea why I can't just use this scalar in subsequent measures but I'll read up on it.

 

Many thanks

 

Jake