March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
For a user given date range(single column)display data
Requirement:
starting before the start date and ending at the end date
starting before the start date and ending before the end date
starting after the start date and ending before the end date
starting after the start date and ending after the end date
starting and ending within the date range
starting and ending at the specified range
data available
A table contains the cols as(with other cols not relevant to the problem)
Start Date
End Date
Inventory item
Solved! Go to Solution.
@RUPSY777 , With an independent date table
measure =
var _max = maxx(allselected('Date'), 'Date'[Date])
var _min = minx(allselected('Date'), 'Date'[Date])
return
calculate(count(Table[Inventory item]), filter(Table, Table[Start Date] >=Min && Table[End Date] = _max))
same way build others
Hi, @RUPSY777
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Please share some sample data( in excel ) and expected result.It will help to provide the appropriate solution.
Best Regards,
Community Support Team _ Eason
Hi, @RUPSY777
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Please share some sample data( in excel ) and expected result.It will help to provide the appropriate solution.
Best Regards,
Community Support Team _ Eason
@RUPSY777 , With an independent date table
measure =
var _max = maxx(allselected('Date'), 'Date'[Date])
var _min = minx(allselected('Date'), 'Date'[Date])
return
calculate(count(Table[Inventory item]), filter(Table, Table[Start Date] >=Min && Table[End Date] = _max))
same way build others
Hi thank you for your response..
Can you refer to which date you are referring to in the below highlighted syntax?
var _max = maxx(allselected('Date'), 'Date'[Date])
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
72 | |
55 |