Forum Discussion

AlexD123's avatar
AlexD123
New Member
4 years ago
Solved

Help With Multiple IF Measure

Hi,    I am looking to recreate an existing Crystal Report Formula in DAX as a measure. Please could someone advise. I will be using a YEARMONTH Slicer and a seprate dates table containing the usua...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    AlexD123 , use correct column and table name

     

    if ( year(urvPMContractAnalysisDD_WithPCOEstCost[Date]) < year([ThroughMth]) ,
    if ( month(urvPMContractAnalysisDD_WithPCOEstCost[Date]) < month([ThroughMth]) ,
    [rvPMContractAnalysisDD_WithPCOEstCost[ProjCost] , urvPMContractAnalysisDD_WithPCOEstCost[CurrEstCost]),0)

amitchandak's avatar
amitchandak
Super User
4 years ago

AlexD123 , use correct column and table name

 

if ( year(urvPMContractAnalysisDD_WithPCOEstCost[Date]) < year([ThroughMth]) ,
if ( month(urvPMContractAnalysisDD_WithPCOEstCost[Date]) < month([ThroughMth]) ,
[rvPMContractAnalysisDD_WithPCOEstCost[ProjCost] , urvPMContractAnalysisDD_WithPCOEstCost[CurrEstCost]),0)