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
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])
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 |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |