Forum Discussion

surajde's avatar
surajde
Helper I
3 years ago

Calculating maxifs

Hi Team,    Please help calculating below MS Excel data using maxif funciton. Below is dummy data. I need to calculate result in Deferred Hours in PowerBI dashboard. Below is excel formula that wor...
Need Help
Show and Tell
surajde's avatar
surajde
Helper I
3 years ago

Do I need to create index column? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi surajde ,

    In the Excel formula, you seem to have a specified the cell. So you need to create an index column. You can create it in Power Query. Or you can refer to  the document: DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.