Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sum by month

Hi everyone, i need help to do a very simple calculation but i can't find the right way to do it. I have already readed many post but no one with my case.

 

So i have two tables, one with the data and the other one is just the date table.

 

the data table has de following format:

the date table hasta the following format:

 

So i want a visualization having the "month-year" column from the data table, and the sum of "cant" for that month-year. The tables are already relationed.

But i just cant get it, it only brings me the current month summarize.

 

 

and i want

 

 

what can i do in this case?

thanks in advance, cheers from arg.

Need Help
  • mattww's avatar
    mattww
    4 years ago

    Hi Anonymous , are you able to share your pbix. It looks likely to be a filtering or relationship issue

6 Replies

  • mattww's avatar
    mattww
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    Hi Anonymous , are you able to share your pbix. It looks likely to be a filtering or relationship issue

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Can´t share de pbix because it's a direct query to a oracle database. It's strange because with another dataset i could do it with out a problem. Could be something on the dataset?

      • mattww's avatar
        mattww
        Icon for Responsive Resident rankResponsive Resident
        4 years ago

        No worries, are there many filters affecting that visual, or do you have any CALCULATE measures with filters in them? 

         

        What happens when you set the month-year field in your visual to "Show items with no data" (see here)