Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
61 | |
54 | |
27 | |
16 | |
9 |