Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |