Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 

    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

lbendlin's avatar
lbendlin
Super User
5 years ago

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.