Forum Discussion

nhodges's avatar
nhodges
Icon for Helper I rankHelper I
3 years ago

C# formula to DAX

I need help converting this C# formula to DAX. when I get to the italics part of this formula (below) my IF statement is breaking in DAX. 

 

 

 

"if (wrkgrp.Contains(""unsubmitted""))
{

Logfiletype = ""UnSubmitted"";
}
else if (DateTime.ParseExact( ""InitialAdjDate"" TxnSubmitDataTime.ToString(""MM/dd/yyyy"") == item.UpdatedDataTime.ToString(""MM/dd/yyyy"") && !inststs. InstPlansts.ToLower().Contains(""stop""))
{
Logfiletype = ""New Record"";
}
else if (inststs.ToLower().Contains(""stop""))
{
Logfiletype = ""STOPPED"";
}
else if ( ""lastMonitoringCheckDate"" == null)
{ Logfiletype = ""New Record""; }

 


else if (DateTime.ParseExact( ""lastMonitoringCheckDate"").ToString(""MM/dd/yyyy"") == item.UpdatedDataTime.ToString(""MM/dd/yyyy""))

{

if (String.IsNullOrEmpty(item?.MonitoringElgChks.TOBROccured) && lastmemo.Contains(""moved from original BAN""))
{ Logfiletype = ""New Record - TOBR""; }

 

 

 


else
{
if (DateTime.ParseExact( ""lastMonitoringCheckDate"".ToString(""MM/dd/yyyy"") == item.CreatedDateTime.ToString(""MM/dd/yyyy""))
{ Logfiletype = ""Monitoring - TOBR""; }
else { Logfiletype = ""Monitoring""; }
}
}

else
{

 


Logfiletype = ""Follow Up Credit"";
}"

1 Reply

  • nhodges ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    Share logic, we might not be well versed with C#