Forum Discussion
mmoeller
6 years agoRegular Visitor
Date Range Look-up in M
Hi, I'd like to implement a Date Range Look-Up in M. I know how to do this in DAX and have succesfully built it there using this code: ComplianceLocation = CALCULATE(VALUES(AssignedLocatio...
edhans
6 years agoCommunity Champion
This is probably pretty easy to do, but very difficult without sample data tables to play with along with the expected ouput. I understand what your DAX measure is doing but I don't know what those fields or tables look like.
DAX doesn't pivot data really. DAX is for analysis. Power Query is for modeling.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum