Create a column with Conditions

Hi there. A calculated column can be created either in DAX or in Transform Data (Power Query Editor). You posted this in the power query forum, but I'd suspect this would normally made in DAX.

If you'd like to do this in DAX, quick google gives me https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns#create-a-calculated-column-that-uses-an-if-function

If you'd like to do this in power query, it is very simple. You could create a conditional column and just plug in the requirements. https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything

Hi Anonymous ,

In Power Query M code:

if [Unique count] = "Yes"
  and [Recurrency] = "Recurrent"
  and List.Contains({"Cancelled", "Hold"}, [Status Description])
  and [Date Approved] = "Not Approved"
  and List.Contains({"Monthly", "Monthly(Per-User)"}, [Period])
then [Amount] * 12
else //your escape output, like null or 0

In DAX

_recurrentAmount =
IF(
  yourTable[Unique Count] = "Yes"
  && yourTable[Recurrency] = "Recurrent"
  && yourTable[Status Description] IN {"Cancelled", "Hold"}
  && yourTable[Date Approved] = "Not Approved"
  && yourTable[Period] IN {"Monthly", "Monthly(Per-User)"},
  yourTable[Amount] * 12,
  //your escape output, like null or 0
)

Pete

Thank you all.. 🙂