Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm new to Power BI and looking to solve the following issue.
I'd like to be able to add a new column using M (or dax if that is the only way) to a table that looks up the nearest greater date from another table column, as below.
Any suggestions?
Thanks
Ian
Solved! Go to Solution.
here is a DAX solution
Column = MINX(FILTER('Table (2)','Table (2)'[Date]>'Table'[date]),'Table (2)'[Date])
Proud to be a Super User!
here is a DAX solution
Column = MINX(FILTER('Table (2)','Table (2)'[Date]>'Table'[date]),'Table (2)'[Date])
Proud to be a Super User!
you are welcome
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |