Forum Discussion

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

IF Statement for DATESBETWEEN

    Hello All, Have run into an issue and looking for some urgent help.   I have the following Measure:   BM_RPX_EquipID = CALCULATE(SUM(RPXNetwork[Total_EquipmentIdentificationCount])/sum(RP...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI rsbin 

    BM_RPX_EquipID = 
VAR max_dt = IF ( MAX (Calendar[Date])= Today(),MAX(Calendar[Date])-1, MAX(Calendar[Date]) )
return CALCULATE(SUM( RPXNetwork[Total_EquipmentIdentificationCount]) /sum(RPXNetwork[Total_Count]), ALL(GeneralStatistics),DATESBETWEEN( 'Calendar'[Date],MIN('Calendar'[Date]), [max_dt]))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI rsbin 

BM_RPX_EquipID = 
VAR max_dt = IF ( MAX (Calendar[Date])= Today(),MAX(Calendar[Date])-1, MAX(Calendar[Date]) )
return CALCULATE(SUM( RPXNetwork[Total_EquipmentIdentificationCount]) /sum(RPXNetwork[Total_Count]), ALL(GeneralStatistics),DATESBETWEEN( 'Calendar'[Date],MIN('Calendar'[Date]), [max_dt]))
rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
6 years ago

Hello Anonymous 

 

Looks like your solution is working perfectly.  Thank you so much for the quick response.

Can't test it completely due to other ongoing data issues, but so far looking real good.

Kudos and Thanks Again!!

 

Regards,