Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello Power BI Experts,
I am currently working on defining a dashboard for which all the metric calculations are based on the Summaries(Date Range,Type-Monthly,Weekly,Yearly ) , Location and Department.
To start of with i started with the Date Range
I created a Date table ,joined to the main table.Then in the main table i created a measure(indate Range) and dashboardcount. The count i see is more than what i see it manually
DATE TABLE SYNTAX:
RECORD_ID | START_DATE | END_DATE |
16687339 | 1/15/24 8:50 PM | 1/17/24 7:11 PM |
16709054 | 1/22/24 10:03 AM | 1/27/24 8:56 PM |
16649877 | 1/5/24 6:03 AM | 1/6/24 5:32 PM |
16707403 | 1/21/24 2:38 PM | 1/24/24 5:13 PM |
16732660 | 1/28/24 3:06 AM | 1/31/24 6:13 PM |
16685134 | 1/14/24 8:16 PM | 1/16/24 6:55 PM |
16635276 | 1/1/24 3:24 PM | 1/3/24 11:04 AM |
16733788 | 1/28/24 3:54 PM | 1/29/24 6:00 PM |
16653543 | 1/5/24 10:33 PM | 1/6/24 11:04 AM |
16635584 | 1/1/24 5:40 PM | 1/3/24 3:39 PM |
16692579 | 1/17/24 12:24 PM | 1/17/24 9:05 PM |
16700030 | 1/18/24 10:53 PM | 1/19/24 4:25 PM |
16674920 | 1/11/24 3:59 PM | 1/13/24 9:02 PM |
16681518 | 1/13/24 8:07 AM | 1/19/24 8:40 PM |
16724261 | 1/25/24 4:22 PM | 1/27/24 10:54 AM |
16634884 | 1/1/24 1:03 PM | 1/17/24 12:19 PM |
16682816 | 1/13/24 6:26 PM | 1/14/24 6:48 PM |
16703587 | 1/19/24 10:21 PM | 1/20/24 1:43 PM |
16679834 | 1/12/24 4:57 PM | 1/12/24 11:14 PM |
16730758 | 1/27/24 9:51 AM | 1/29/24 8:00 PM |
16685585 | 1/15/24 3:58 AM | 1/19/24 6:52 PM |
16695821 | 1/18/24 8:52 AM | 1/19/24 6:56 PM |
16685086 | 1/14/24 7:46 PM | 1/15/24 3:20 PM |
16737786 | 1/29/24 5:45 PM | 1/31/24 9:19 PM |
16653049 | 1/5/24 6:52 PM | 1/7/24 11:50 AM |
16725374 | 1/26/24 1:15 AM | 1/30/24 6:39 PM |
16664687 | 1/7/24 10:36 PM | 1/9/24 6:00 AM |
Solved! Go to Solution.
As you mentioned i changed the date format to exclude the time stamp by "many to one" and "both" and it worked. Thanks much for the lead.
Calendar tables have Date columns that are actually DateTime type values pegged at midnight. You will have to define what "Range" means for you. Is 1/15/24 8:50 PM counting as 1/15/24 or 1/16/24 ? Or do you need the fractions too?
What is the expected outcome based on your sample data?
As you mentioned i changed the date format to exclude the time stamp by "many to one" and "both" and it worked. Thanks much for the lead.
Hello lbendlin,
Thank you so much for getting back to me. The expected outcome is count of the dashboard
What is the expected outcome based on your sample data?
User | Count |
---|---|
23 | |
18 | |
16 | |
13 | |
13 |