Forum Discussion

FatalLordes's avatar
FatalLordes
New Member
2 years ago

New User - Question about Date Manipulation

Hi All.  Very new user to PowerBI.  My data source presently is a CSV file.  It includes date start and end fields.  What I need to do is run a filter on the date start as I only want to show data wh...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

FatalLordes , If you need it with dat selection.

 

Create a disconnected date table. Do not join with date of your table

 

//Date1 is independent Date table
new measure =
var _max1 = maxx(allselected(Date1),Date1[Date])
var _min = _max1+7
var _max = _max1+28
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

 

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI