The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Good morning
Hoping you can help, I have the below formula in Excel but I need it converting to DAX if someone can help me 🙂
=IF(AND([@Shipper]="",[@[Shipper Company]]=""),"No Shipper Information",IF([@[Shipper Company]]="",[@Shipper],[@[Shipper Company]]))
Solved! Go to Solution.
if it calculated column
IF(
AND('Table'[Shipper]="",'Table'[Shipper Company]=""),"No Shipper Information",
IF('Table'[Shipper Company]="",'Table'[Shipper],'Table'[Shipper Company]))
if it calculated column
IF(
AND('Table'[Shipper]="",'Table'[Shipper Company]=""),"No Shipper Information",
IF('Table'[Shipper Company]="",'Table'[Shipper],'Table'[Shipper Company]))