Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |