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 usual year, month etc etc

 

if DatePart('yyyy',{urvPMContractAnalysisDD_WithPCOEstCost.Mth}) < DatePart('yyyy',{?ThroughMth}) then
if DatePart('yyyy',{urvPMContractAnalysisDD_WithPCOEstCost.ProjMth}) < DatePart('yyyy',{?ThroughMth}) then
{urvPMContractAnalysisDD_WithPCOEstCost.ProjCost}
else
{urvPMContractAnalysisDD_WithPCOEstCost.CurrEstCost}
else
0

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)

2 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AlexD123 ,


    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your problem.


    Best Regards,
    Stephen Tao