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.
Hi, I got table Dossiers with a Date column (type Date/time formatted as shown):
Date |
1-1-2021 |
1-1-2021 |
2-1-2021 |
2-1-2021 |
2-1-2021 |
I want to visualize that date 1-1-2021 exists 2 times and date 2-1-2021 exists 3 times.
(Which visual exactly does not yet matter much.)
How?
Thanks.
Solved! Go to Solution.
Hey @Dicko ,
create the following measure:
Amount Rows = COUNTROWS( Dossiers )
Now you can add the date column and the measure in a table or bar chart visual and you see the amount of rows by date.
Hey @Dicko ,
create the following measure:
Amount Rows = COUNTROWS( Dossiers )
Now you can add the date column and the measure in a table or bar chart visual and you see the amount of rows by date.
Thanks, how easy can it be?
Hey @Dicko ,
that's normal. When you start with DAX you most of the time think too complicated 😉
But I'm happy that it works now.
Best regards
Denis
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
63 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |