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.
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"";
}"
@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#
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |