Forum Discussion
Calculate different sources DAX:
Hi Friends!
I am having such problem when I trying to sum different sources , any Ideas?
LIMITE X =
VAR ano =
FORMAT ( YEAR ( MAX ( FatoOpex[Data] ) ) - 1; "####" )
RETURN
CALCULATE(
FILTER(FatoOpex;
FatoOpex[numCiclo]="1" &&
RELATED(FatoLimite[numAno])=ano);
IF(FatoOpex[newIdDiretoria]="37";
SUM(FatoOpex[valor]);SUM(FatoLimite[numLimite]))
)
1 Reply
- parry2k
Super User
Anonymous Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
