Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Use DAX or Power Query to create a calculated column

 I have a table called Address as shown below I want to use power query or dax to create calculated column to achieve AddressStatus (current and previous address) as shown below How can...
Need Help
Show and Tell
Tips and Tricks
az38's avatar
az38
Community Champion
4 years ago

Hi Anonymous 

what is the rule to define the current address? any indexes or dates or smth else?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

az38 - there is no rule that define current address. The table was parsed on JSON, no index, no date.