Forum Discussion

gardas_swathi's avatar
gardas_swathi
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Display sum only for max Inventory available date

Table - DAily Avg DateID DailyAvg 01/01/2020 500 01/07/2020 500 01/14/2020 500 01/21/2020 500 Table Inventory DateID Inventory 01/01/2020 2000 01/02/2020 2222 ...
gardas_swathi's avatar
gardas_swathi
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

HI Amit,

 

Thanks for your response. my Data model already has daily average calculated and its populated from the source . I am able to get the avg for the 4 weeks. Its straight forward in my scenario. SUM(DailyAvg)/28

 

All i need to do is display this value based on the inventory max availability date.  If the inventory max date is 9/2 i need to display the value for that date

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    gardas_swathi , not very clear. But you can get data for the last available date. But will not work when day is axis or group, then you need use allexcept

     

    lastnonblankvalue(Table[Date],sum([Value]))

     

    calculate( lastnonblankvalue(Table[Date],sum([Value])),allexcept (Table[Week]))