Forum Discussion

vehau1's avatar
vehau1
Helper I
6 years ago
Solved

Custom columns problem

an hour ago I have a fairly easy problem, but I dont get it right. I want to calculate "Prognosis" Date -DateWvals- -RunningTOtal- -RunningPlannedTotal- -Prognosis- 1.1.2020   1.1.2020...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    vehau1 , to me it seems like current-day value - last day value one column _ last day value on another column

     

    In the measure, you can get last day value like

    Last Day Non Continous = CALCULATE(sum('order'[Qty]),filter(all('Date'),'Date'[Date] =MAXX(FILTER(all('Date'),'Date'[Date]<max('Date'[Date])),Table['Date'])))
    Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))

     

    As a new column, you can try like

    RunningTOtalast day = maxx(filter(Table,[Date] =earlier([Date] )-1),[RunningTOtal])

amitchandak's avatar
amitchandak
Super User
6 years ago

vehau1 , to me it seems like current-day value - last day value one column _ last day value on another column

 

In the measure, you can get last day value like

Last Day Non Continous = CALCULATE(sum('order'[Qty]),filter(all('Date'),'Date'[Date] =MAXX(FILTER(all('Date'),'Date'[Date]<max('Date'[Date])),Table['Date'])))
Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))

 

As a new column, you can try like

RunningTOtalast day = maxx(filter(Table,[Date] =earlier([Date] )-1),[RunningTOtal])