Can I take the same column and split it into 2 columns with separate date filters?

[Anonymous]

We have a custom built report that we are trying to get to show us Year to date sales qty as well as passed year sales qty in columns next to each other. Is there a straightforward way of doing this? We are using "Sales_Qty" column from ItemSalesAndProfit table in Business Central to power BI desktop.

[parry2k]

@Anonymous if the other two fact tables are 1 to 1 relationship then you just need to connect your date table to one of the fact tables that contain the date columns.

[parry2k]

@Anonymous there are tons of posts on how to get previous year sales, the fundamental here is that you need to date dimension in your model to get this going. And this dimension can be easily added, you can check my post here.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

@parry2k That is very helpful, thank you. I have added the date table but I don't know how to link it to my two other data sets or have it display as 2 separate columns (for example "Year to Date sales qty" and "Prior Year to Date sales qty". These are the data sets we are utilizing: