Hi- still learning my way around Power Bi. I have two fact tables, one that holds all sales data and the other that has a specific list of our retail outlets that has a date of when the shops last had a refit. I want to create a visual table that shows the shop name, date of refit, which can obviously come straight from the second table, then with two further columns that show the previous years sales and the 12 month sales after the refit.
When I use the dateadd function based the date column in refit table I get an error saying that the dates aren’t contiguous. If i use a date table it just gives my the data based on a slicer rather than picking up the date of the refit. I have about 40 stores to look at so really need to show in one visual for the end users!
Thanks for any help!