Forum Discussion
DAX formula help
I would need help creating DAX and designing data model. Table1: start date end date Unit $ value 1/1/2010 1/1/2011 A 100 1/3/2010 1/3/2011 B 200 1/4/2010 1/4/2011 C 300 ...
There is no relationship between date and table 1. Does this formula works?
amitchandak thanks amit , the formula is working. But there are a couple of challenges.
1) The defult set to Today's date
2) User needs calendar option in slicer.
I have gone through below Video in You tube. this workaround is working but how to merge these two formuals.
https://www.youtube.com/watch?v=zhWtU0DynCk
My formula as below to set as default value to todays date.
WRITTEN =
var _max = SELECTEDVALUE('Date'[Date],TODAY())
return
calculate([WRITTEN PREMIMUM], filter('Active Policy', _max>=[DATE2] && _max<=[DATE1]))