Forum Discussion
Vinutha
1 year agoFrequent Visitor
Date Range with Date Slicer
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 Depa...
- 1 year ago
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.
lbendlin
1 year agoSuper User
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?