Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
hi SuperUsers,
I read a number of post regarding the solution to translate MAXIFS from Excel into DAX but I'm not able to make it work.
Here is a sample of the table i have.
I am trying to find out for each Order-Line (most left column), which month # has not been invoiced.
If I am writing in Excel, I will be able to find out by using the formula below.
MINIFS(Month#,Order-Line Column A:A = Order-Line A2, Today>Contract Month Column K:K,0)
Can someone advise me , how to convert this to DAX ?
Solved! Go to Solution.
hi
Managed to finally solve the issue with this formula
hi
Managed to finally solve the issue with this formula
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
106 | |
105 | |
90 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
92 | |
88 |