Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
nhodges
Helper I
Helper I

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 1
amitchandak
Super User
Super User

@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#

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors