Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |