Monday, February 22, 2021

DAX - LastValue

.qtdObitosPT_Diario =
var AcumToday = FAT_COVID_PT_Matrix[obitos]
var AcumLastday = MAXX(FILTER(FAT_COVID_PT_Matrix, FAT_COVID_PT_Matrix[data_dados]=(EARLIER(FAT_COVID_PT_Matrix[data_dados])-1)),FAT_COVID_PT_Matrix[obitos])
return
if (len(AcumToday) >0 , AcumToday - AcumLastday)

No comments:

Post a Comment

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE