How do I get Invoice from Aug and the Difference from July on the same date?

[MMatthews]

How do i get the August to show the Inv for Aug and the Difference for Jul?

[MMatthews]

I want to make this clear.  The Manger Commision takes the Invoice From Aug and the Difference from July and add them together under August date.  I have them seperated out but i need them together.

[v-chenwuz-msft]

Hi @MMatthews ,

Please provide some example data that fully covers your issue and expect output.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MMatthews]

I hope this enough.

[parry2k]

@MMatthews check this video on my YT channel and tweak it as you see fit Learn how to compare MTD sales as of date with same number of days in previous months - Part 6 - You...

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.