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.
Sales Table
Date Table
I would like to create a summarized table like this
I am able to create a summarized table for each day using the following code
Please could somebody assist?
Sample File https://easyupload.io/bx07gx
Thank you
Solved! Go to Solution.
Hi @Kurt4597 ,
try this:
ADDCOLUMNS(
SUMMARIZE(
'Sales Table',
'Date Dim'[Date],
'Sales Table'[Shop Name]
),
"DailyClickCount",DISTINCTCOUNT(ClicksByDay[clickref])
)
Please mark this answer as solution, if it helps.
Hello, I appear to get this error message from your solution
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |