Forum Discussion

JEM_Systems's avatar
JEM_Systems
Helper I
3 years ago

MINIFS Excel Formula equivalent on DAX

Hi, I'm trying to apply a formula with network days that I found on excel on Power BI, but on power BI I cannot use the formula MINIFS, could someone help me?

This is the MINIFS on Excel:
=MINIFS([day],[month],[@month],[year],[@year])

I have all these columns on PBI but I'm not able to create a DAX function to return the same value as Excel, could someone help me?


Need Help

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    do you have an example of the data and the expected outcome?

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť