Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Ola
Acumular os valores respeitando duas condições:
Solved! Go to Solution.
@Vilmar ,
Try using this measurement:
_Esperado =
VAR _currentDate = MAX ('Table'[Data])
VAR _currentValue = MIN ('Table'[Valor])
VAR _minDate = MINX('Table', 'Table'[Data])
VAR _lastNegative = CALCULATE(MAX('Table'[Data]), FILTER(ALL('Table'), 'Table'[Data] < _currentDate && 'Table'[Valor] < 0))
VAR _lastPositive = CALCULATE(MAX('Table'[Data]), FILTER(ALL('Table'), 'Table'[Data] < _currentDate && 'Table'[Valor] >= 0))
VAR _tbConsecutiveDate =
FILTER(
SUMMARIZE(
FILTER(ALL('Table'), 'Table'[Data] <= _currentDate),
'Table'[Data],
"NextDate", DATEDIFF('Table'[Data], CALCULATE(MIN('Table'[Data]), FILTER(ALL('Table'), 'Table'[Data] > EARLIER('Table'[Data]))), DAY)
),
[NextDate] = 1 || 'Table'[Data] = _currentDate
)
VAR _positivesValues =
CALCULATE (
SUMX ( FILTER ( 'Table', 'Table'[Valor] >= 0 ), 'Table'[Valor] ),
FILTER ( ALL ( 'Table'[Data] ), 'Table'[Data] > _lastNegative && 'Table'[Data] <= _currentDate), _tbConsecutiveDate
)
VAR _negativeValues =
CALCULATE (
SUMX ( FILTER ( 'Table', 'Table'[Valor] < 0 ), 'Table'[Valor] ),
FILTER ( ALL ( 'Table'[Data] ), 'Table'[Data] > _lastPositive && 'Table'[Data] <= _currentDate), _tbConsecutiveDate
)
RETURN
IF ( _currentValue < 0, _negativeValues, _positivesValues )
@Vilmar ,
Try using this measurement:
_Esperado =
VAR _currentDate = MAX ('Table'[Data])
VAR _currentValue = MIN ('Table'[Valor])
VAR _minDate = MINX('Table', 'Table'[Data])
VAR _lastNegative = CALCULATE(MAX('Table'[Data]), FILTER(ALL('Table'), 'Table'[Data] < _currentDate && 'Table'[Valor] < 0))
VAR _lastPositive = CALCULATE(MAX('Table'[Data]), FILTER(ALL('Table'), 'Table'[Data] < _currentDate && 'Table'[Valor] >= 0))
VAR _tbConsecutiveDate =
FILTER(
SUMMARIZE(
FILTER(ALL('Table'), 'Table'[Data] <= _currentDate),
'Table'[Data],
"NextDate", DATEDIFF('Table'[Data], CALCULATE(MIN('Table'[Data]), FILTER(ALL('Table'), 'Table'[Data] > EARLIER('Table'[Data]))), DAY)
),
[NextDate] = 1 || 'Table'[Data] = _currentDate
)
VAR _positivesValues =
CALCULATE (
SUMX ( FILTER ( 'Table', 'Table'[Valor] >= 0 ), 'Table'[Valor] ),
FILTER ( ALL ( 'Table'[Data] ), 'Table'[Data] > _lastNegative && 'Table'[Data] <= _currentDate), _tbConsecutiveDate
)
VAR _negativeValues =
CALCULATE (
SUMX ( FILTER ( 'Table', 'Table'[Valor] < 0 ), 'Table'[Valor] ),
FILTER ( ALL ( 'Table'[Data] ), 'Table'[Data] > _lastPositive && 'Table'[Data] <= _currentDate), _tbConsecutiveDate
)
RETURN
IF ( _currentValue < 0, _negativeValues, _positivesValues )
Not sure if this is what you mean, but please try this measure expressions below in a table visual with your Date column. Replace Table with your actual table name. If not, please clarify further.
Esperado =
VAR thisdate =
MAX ( Table[Data] )
VAR thisvalue =
MIN ( Table[Valor] )
VAR positives =
CALCULATE (
SUMX ( FILTER ( Table, Table[Valor] >= 0 ), Table[Valor] ),
FILTER ( ALLSELECTED ( Table[Data] ), Table[Data] <= thisdate )
)
VAR negatives =
CALCULATE (
SUMX ( FILTER ( Table, Table[Valor] < 0 ), Table[Valor] ),
FILTER ( ALLSELECTED ( Table[Data] ), Table[Data] <= thisdate )
)
RETURN
IF ( thisvalue < 0, negatives, positives )
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Vilmar - Pode não parecer no início, mas acredito que você precisa de uma variação de Cthulhu:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739#M211
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |