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.
Hello,
I’m trying to get the sum of just the first day of the year of the applied slicer. But I can’t figure out how to use just the year of the slicer to get it done.
In the CALCULATE() when I use just the ALLEXCEPT() I get the sum of all values and when I use the ALLEXCEPT() with FILTER() I get a blank result.
I’ve searched for similar issues, but couldn’t find any answer that solve this problem.
Solved! Go to Solution.
Hi, @r_fioretti
You may need to encapsulate all conditions into function 'filter'.
Please check if the following formula works for you.
Saldo Inicial(YTD) =
VAR bg_dt =
FIRSTDATE ( DATESYTD ( 'Caixa(YTD)'[Data] ) )
VAR si =
CALCULATE (
SUM ( 'Caixa(YTD)'[Valor] ),
FILTER (
ALLEXCEPT ( 'Caixa(YTD)', 'Caixa(YTD)'[Data] ),
'Caixa(YTD)'[Valor] = "Saldo Inicial"
&& 'Caixa(YTD)'[Data] = bg_dt
)
)
RETURN
si
Best Regards,
Community Support Team _ Eason
Hi, @r_fioretti
You may need to encapsulate all conditions into function 'filter'.
Please check if the following formula works for you.
Saldo Inicial(YTD) =
VAR bg_dt =
FIRSTDATE ( DATESYTD ( 'Caixa(YTD)'[Data] ) )
VAR si =
CALCULATE (
SUM ( 'Caixa(YTD)'[Valor] ),
FILTER (
ALLEXCEPT ( 'Caixa(YTD)', 'Caixa(YTD)'[Data] ),
'Caixa(YTD)'[Valor] = "Saldo Inicial"
&& 'Caixa(YTD)'[Data] = bg_dt
)
)
RETURN
si
Best Regards,
Community Support Team _ Eason
Hi
Firts get the year selected ==> var selectedyear=selectevalue(date[year])
calculate the first day of the year= var firstday=calcualte(min(date[Date]),date[year]=selectedyear)
and after your sum
calculate(sum(x), date[date]=firstday)
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |