Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have two tables. They are connected by date. And Date in table one is Unique.
I want to sum the values from table2 two in a column in table one.
Any tips?
Solved! Go to Solution.
Try this,
Sum of Value =
var _value = CALCULATE(SUM(Table2[Value]),FILTER(ALL(Table2),Table2[Date]=MIN(Table1[Date])))
return IF(ISBLANK(_value),0,_value)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
same issue here, any solution? 🙂 thanks!
Try this,
Sum of Value =
var _value = CALCULATE(SUM(Table2[Value]),FILTER(ALL(Table2),Table2[Date]=MIN(Table1[Date])))
return IF(ISBLANK(_value),0,_value)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@RickardBengzon
Add the following column in Table 1
Total = CALCULATE ( SUM ( Table2[Value]) )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I don't get any result from that If I remove "CALCULATE" and only use sum I get the total sum of all value for all dates
@RickardBengzon
Please try this:
Total =
SUMX(
FILTER( Table2 , Table2[Date] = Table1[Date] ),
Table2[Value]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Seems legit but still doesn't work. I get no values at all... Thinking if there is somethings wrong with the date-connection... But they both seeem to be the same...
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |