Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Separating months from different years

Hello everyone!   Really hoping someone could help me with this, I am trying to show Sales data from 2 years, but Power BI sums up data from the same months but different years. I can fix that by u...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Anonymous ,

     

    Do you have a date dimension in place? If so, I'd create a new column which concatenates Year and Month, something like 04/2022 or April 2022. If you use that attribute, PBI will automatically distribute your data per month and year instead of grouping everything on just month.

     

    Let me know if this works for you 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi Anonymous ,

 

Do you have a date dimension in place? If so, I'd create a new column which concatenates Year and Month, something like 04/2022 or April 2022. If you use that attribute, PBI will automatically distribute your data per month and year instead of grouping everything on just month.

 

Let me know if this works for you 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/