Forum Discussion
superjam
Helper II
Helper IIYTD for calculated values not working
Hello PowerBI experts! I have 3 tables: 1. Balances Investment balances for each month, like so: Date Final Balance 31-12-22 100.000 31-01-23 101.000 28-...
superjam Here you go:
Measure = VAR __MesAnoNUm = MAX('Calendar'[MesAñoNum]) VAR __Table = FILTER ( SUMMARIZE( ALLSELECTED('Calendar'), [MesAño], [MesAñoNum], "__Value", [Revenue month] ), [MesAñoNum] <= __MesAnoNum ) VAR __Result = SUMX( __Table, [__Value] ) RETURN __Result
mickey64
Super User
Super UserIs '800' correct?
Type Date Amount
Income 31-01-23 1.500
Income 31-03-23 800
Income 31-03-23 20.000
Withdraw 31-03-23 -10.000
Income 30-04-23 1.400
Withdraw 30-04-23 -18.000
Income 31-05-23 1.300
Income 31-07-23 1.600
Income 31-07-23 40.000
