Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
.Saldo Liquido 2 = CALCULATE(FIRSTDATE(dim_data[data]))
In this case, always the 7/18/2017
The thing is: I want to subtract .Entradas from .Saldo Bancario only on the first day of my filter, creating .Saldo Liquido.. But, as create the measure, the code always add .Entradas from other days on the Measure.. And I only want the first day.
Saldo Liquido = CALCULATE( SUM(fato_saldobco[valor]),filter(dim_data,dim_data[datakey]=MIN(dim_data[datakey])))- calculate(SUMX(FILTER(fato_financeiro,fato_financeiro[operacao]="R"),fato_financeiro[saldo_titulo]),FILTER(dim_data,dim_data[datakey]=min(dim_data[datakey])))
Solved! Go to Solution.
Hi @gustavocunha76,
Please create a measure like below:
Saldo Liquido = var FirstDay=CALCULATE(FIRSTDATE(dim_data[data]),ALLSELECTED(dim_data))
Return
IF(Saldo Liquido 2=FirstDay,
CALCULATE( SUM(fato_saldobco[valor]),filter(dim_data,dim_data[datakey]=MIN(dim_data[datakey])))- calculate(SUMX(FILTER(fato_financeiro,fato_financeiro[operacao]="R"),fato_financeiro[saldo_titulo]),FILTER(dim_data,dim_data[datakey]=min(dim_data[datakey]))),Blank())
Best Regards,
Qiuyun Yu
Hi @gustavocunha76,
Please create a measure like below:
Saldo Liquido = var FirstDay=CALCULATE(FIRSTDATE(dim_data[data]),ALLSELECTED(dim_data))
Return
IF(Saldo Liquido 2=FirstDay,
CALCULATE( SUM(fato_saldobco[valor]),filter(dim_data,dim_data[datakey]=MIN(dim_data[datakey])))- calculate(SUMX(FILTER(fato_financeiro,fato_financeiro[operacao]="R"),fato_financeiro[saldo_titulo]),FILTER(dim_data,dim_data[datakey]=min(dim_data[datakey]))),Blank())
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |