cancel
Showing results for
Did you mean:  Helper III

Calculate column

I everyone, I need for you.

I want create a new calculate colum with this sintax

if [DWH.GENNAIO] is null then [Ricavo pesato]/(([FineMese]+1) - [InizioMese]),Table.SelectRows([InizioMese] <= 1 && [FineMese] <= 1 then [DWH.GENNAIO]

I would like to create an if else with the condition that certain dates are filtered.
For example I say
if month is zero then revenue / month where month start <= 1 and month end <= 1 otherwise month.
In dax I did this:

Colonna 2 = IF(Merge1[DWH.GENNAIO] = BLANK(),CALCULATE(SUM(Merge1[Ricavo pesato])/SUM(Merge1[DiffMese]),Merge1[MeseInizio] <= 1 && 1 <= Merge1[MeseFine]),Merge1[DWH.GENNAIO])

but this formula gives me a problem when I create the high months, it tells me that there is a circular dependency and I believe it depends on the fact that I always use the condition:

start of month <= 1 and end of month <= 1

with different months

Thanks a lot to those who can help me

1 ACCEPTED SOLUTION  Community Support

@tarz

This dax is not correctly written. I am sure what exact your are expecting but try the correct formula below:

Colonna 2 = IF(Merge1[DWH.GENNAIO] = BLANK(),
SUM(Merge1[Ricavo pesato])/CALCULATE(SUM(Merge1[DiffMese]), Filter(Merged,                                                 Merge1[MeseInizio] <= 1 && 1 <= Merge1[MeseFine])),
Merge1[DWH.GENNAIO])

However, I am confuse with the <=1 and >=1, doesn't this means all numbers? This probably causes the the circular dependency.

Paul Zheng _ Community Support Team

2 REPLIES 2  Community Support

@tarz

This dax is not correctly written. I am sure what exact your are expecting but try the correct formula below:

Colonna 2 = IF(Merge1[DWH.GENNAIO] = BLANK(),
SUM(Merge1[Ricavo pesato])/CALCULATE(SUM(Merge1[DiffMese]), Filter(Merged,                                                 Merge1[MeseInizio] <= 1 && 1 <= Merge1[MeseFine])),
Merge1[DWH.GENNAIO])

However, I am confuse with the <=1 and >=1, doesn't this means all numbers? This probably causes the the circular dependency.

Paul Zheng _ Community Support Team  Super User

You posted this in the Power Query section. Please confirm if you want M or DAX code. Please provide sample data in usable format (not as a picture) and show the expected outcome.  