Forum Discussion

Analytics4Life1's avatar
Analytics4Life1
Regular Visitor
5 years ago
Solved

How to find variance between columns from separate tables

Here is my data: https://ibb.co/1bH6QSF   I am trying to find the variance (difference) between the first and middle table in terms of expected sales and sale total (these are the actual sales), at...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    5 years ago

    Hi Analytics4Life1 ,

    new date = CONCATENATE("1/",MAX('Table (2)'[Month]))&"/"&max('Table (2)'[Year ])//You can use either CONCATENATE() (which only takes two values, or & to combine Text. Nee to use quotes around any text.

     




    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel


    If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you. 

    Please read this post to get your question answered more quickly:

    https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Analytics4Life1 ,

new date = CONCATENATE("1/",MAX('Table (2)'[Month]))&"/"&max('Table (2)'[Year ])//You can use either CONCATENATE() (which only takes two values, or & to combine Text. Nee to use quotes around any text.

 




Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel


If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you. 

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490