Forum Discussion

m4kaveli's avatar
m4kaveli
Frequent Visitor
5 years ago

Display Value from Prior Line

Hi guys, I'm working with Power BI Desktop connecting to SQL and looking at insurance policy data. What i'm looking to do, is show expiring vs. new policy premium. The end result being that it will ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

m4kaveli , Join the date with date table and try to measures like

 

This Day = CALCULATE(sum('Table'[Estimated Premium]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))

 

Last Day Non Continuous = CALCULATE(sum('Table'[Estimated Premium]),filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

m4kaveli's avatar
m4kaveli
Frequent Visitor
5 years ago

Thanks for the quick response! I think i'm following...what needs to be in the date table?

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    m4kaveli , all with your table to ignore context to get last week, will remove all other filters. Better to have separate table