Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
I am trying to create a table using
table shipments =
SUMMARIZECOLUMNS(
dDate[Year],
dDate[Month],
"shipments Saved",
[Shipments Saved_corrected TEST])
I need to know if I can do this, if yes than how.
And should I be using SUMMARIZE function instead of
Solved! Go to Solution.
Hi,
It works well here:
Please check the filter field [Year] comes from new summarize table but not from original table.
If choosing [Year] from original table to filter, it caused the same issue as you like below:
If you still want to use this [Year] from original table to filter the new summarize table visual, you can create a relationship between them.
See my attached pbix file.
Best Regards,
Giotto
Hi,
It works well here:
Please check the filter field [Year] comes from new summarize table but not from original table.
If choosing [Year] from original table to filter, it caused the same issue as you like below:
If you still want to use this [Year] from original table to filter the new summarize table visual, you can create a relationship between them.
See my attached pbix file.
Best Regards,
Giotto
I am not able to view your file, it is asking for a Power BI update, but its up to date