Forum Discussion

jpdren's avatar
jpdren
Frequent Visitor
8 years ago
Solved

Trouble replicating Excel formula in Power BI

I'm trying to replicate an Excel formula in Power BI. The formula gives me a running average for a selected metric. The Excel formula is: Goal=SUM(range)/((YEAR(LDate)-YEAR(EDate))*12+MONTH(LDate)-MO...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    The second input of the CALCULATE() function should be a column or expression that you would like to filter.  Your second input is just an expression so that formula does not know which already written expression or base data column to apply a filter condition on.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

The second input of the CALCULATE() function should be a column or expression that you would like to filter.  Your second input is just an expression so that formula does not know which already written expression or base data column to apply a filter condition on.