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
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

 

It is really not clear what you are trying to do.  Can you post some sample workbook and show the output you are expecting?

  • 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.