Forum Discussion
Syndicate_Admin
Administrator
AdministratorHow to Know the Difference in Values Between 2 Date Range
Hello, good afternoon everyone! I have a GDP with a date column and a securities column (currency) and I would like to know the monetary difference between 2 selected dates, for example, 01-05-24 ...
CatuabaSelvagem My bad:
Difference Between Days = VAR SelectedDate1 = MINX(ALLSELECTED(Table),[Fecha]) VAR SelectedDate2 = MAXX(ALLSELECTED(Table),[Fecha]) VAR TotalValueDay1 = CALCULATE(SUM(Table), Table[Date] = SelectedDate1) VAR TotalValueDay2 = CALCULATE(SUM(Table), Table[Date] = SelectedDate2) RETURN TotalValueDay2 - TotalValueDay1
Hola @Syndicate_Admin !
Thanks for your help but I'm still getting an error in the function... He says that I lack arguments.
Greg_Deckler
Community Champion
Community ChampionCatuabaSelvagem My bad:
Difference Between Days =
VAR SelectedDate1 = MINX(ALLSELECTED(Table),[Fecha])
VAR SelectedDate2 = MAXX(ALLSELECTED(Table),[Fecha])
VAR TotalValueDay1 = CALCULATE(SUM(Table), Table[Date] = SelectedDate1)
VAR TotalValueDay2 = CALCULATE(SUM(Table), Table[Date] = SelectedDate2)
RETURN
TotalValueDay2 - TotalValueDay1