Forum Discussion

michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
6 years ago

Target Measure doesn't use current month, uses appended query

Hi,   I'm trying to create a target measure. I've got two targets which are the same.   The black line target in a formula target based on a numbers within the system, the red target is manually ...
Need Help
Tips and Tricks
michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi v-eachen-msft ,

 

Yes I do want them in the same line

 

Sorry, I'm still learning DAX. I tried with the code below but I have had no luck. 

IsCurrentMonth = 
IF( 
    SELECTEDVALUE(Appointment[createdon].[Date]) =MONTH(NOW(),[Target], 'Targets- WBAH'[WBAH Target]))

 

The theory I want is

 

If current month, return 'Target', else return 'WBAH Target' 

 

Any suggestions

 

Thanks,

Mike

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi michael_knight ,

 

You could try the following DAX:

IsCurrentMonth =
IF (
    SELECTEDVALUE ( MONTH ( Appointment[createdon] ) ) = MONTH ( NOW () ),
    [Target],
    SELECTEDVALUE ( 'Targets- WBAH'[WBAH Target] )
)

All values you return need to be measure.

 

  • michael_knight's avatar
    michael_knight
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Hi v-eachen-msft 

     

    Give it another go and still no luck. I tweeked your code a bit to make it work and the measure itself is working now, but it isn't showing what I need. It's returning 'Targets' throughout rather than only showing 'Targets' for the current month 

    IsCurrentMonth = 
IF (
    SELECTEDVALUE ( 'Full Date'[Full Date]) = MONTH ( NOW () ),
    [Target],
    SELECTEDVALUE('Targets- WBAH'[Target], 'Targets- WBAH'[WBAH Target]) )

     

     

    Thanks,

    Mike

    • v-eachen-msft's avatar
      v-eachen-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi michael_knight ,

       

      You need to add month() function as MONTH(SELECTEDVALUE('Full Date'[Full Date])). According to your situation, the month is the key to comparison. If you want to compare more carefully, you could refer to the following DAX:

       

      IsCurrentMonth = 
IF (
    MONTH ( SELECTEDVALUE ('Full Date'[Full Date])) = MONTH ( NOW () )
 && YEAR ( SELECTEDVALUE ('Full Date'[Full Date])) = YEAR ( NOW () ),
    [Target],
    SELECTEDVALUE('Targets- WBAH'[Target], 'Targets- WBAH'[WBAH Target]) )