Forum Discussion

rrhutch's avatar
rrhutch
Icon for Helper II rankHelper II
9 years ago

Measure with new Date Slider Value

I have been doing some research on using slicer values for create dynamics measures. However, I am looking for some clarity of developing the measure, since this is my first run at it.   I have two...
Need Help
rrhutch's avatar
rrhutch
Icon for Helper II rankHelper II
9 years ago

Here is a link to an example PowerBI file.

 

Raw data looks like:

 

I would want to create a new column that has values of something like 'Yes' or 'No' or '0' or '1' in TableA where if TableA.[Status] = 'XX' or 'XY' the result would be 'Yes', but if 'XT' or 'XZ' if would determine whether the result is 'Yes' or 'No' based on if TableA.[Decision Date] is <= to the Max date the user selects on the date slider that is pulling from TableB. I would use the 'Yes' or 'No' reuslt to filter the TableA results.

 

As an example, if the user set 1/11/16 the result would look like:

 

 

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

Join your 2 tables on date.

 

Write this measure

Min Selected Date = FIRSTDATE(TableB[UNIQUE DECISION DATE])

and this

Display Result = if(HASONEVALUE(TableA[STATUS]),
	     				if(VALUES(TableA[STATUS]) in ("XX", "XY"),"Yes","No"),
						 if(min(TableA[Decision Date]) >=[Min Selected Date],"Y","N"))

I'm not sure if my logic is quite right, but you can probably fix it from there.


Here is the workbook https://www.dropbox.com/s/5vilq70ai8b02kq/Example.pbix?dl=0

 

Note that the in statement above is new.  It is not supported in the intellisense, but it does work.