Compare DAX and M formulas in Visual Studio Code
Compare DAX and M formulas in Visual Studio Code is really easy with the help of Power BI Sidetools. As it is possible to transfer DAX and M formulas from Power BI desktop to files and to open them in Visual Studio Code, it is possible to compare two files. That’s extremely useful in many cases.
Merge two tables on ID and if before or after date?
I have two tables, a transaction table and a customer table. I make a relationship on the tables based on cusotmer id. But if the customer changes thier address this causes issues as now they are associted with multiple addresses when looking up an order. I want to be able to see the customer info at the time of the transaction. Transaction Table OrderId CustomerId Value Transaction_Date 999 123 10,999 10/11/2021 889 456 5999 3/5/2021 Customer Table CustomerID Address last_change_date 123 123 N North Street 10/8/2021 456 456 W West Street 2/14/2021 123 789 E East Street 1/10/2021 The way it is now is id I wanted to make a the adress for customer 123 dor order 999 it would pull both address we have for the customer. But I want it to be albe to check both cusotmerID and compare the order_Date and check that the order_Date is within the range of of the last_change _dates.
