How do I append 2 columns by a measure or by creating a new calc. column?
1 ACCEPTED SOLUTION
you can try this
sumofcallforecast = sum('Table'[calls forecasted])
sumofcalloffer = sum('Table'[calls offer])
measure = if(ISBLANK('Table'[sumofcallforecast]),'Table'[sumofcalloffer],[sumofcallforecast])
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
