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 ...
Anonymous
Create the following measure, replace the correct table names and columns. Add a slicer for dates and make it single select.
Measure1 =
VAR __DateSelected = MAX('Calendar'[Date]) Return
IF(
__DateSelected >= max(Table[StartDate]) && __DateSelected <= max(Table[EndDate]) ,
1,
0
)
Insert a Table Visual on the canvas, add Start Date, End Date, and other fields you need, Go to Filter Pane and add the new measure and set to equal 1.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂