Forum Discussion

Chamari's avatar
Chamari
New Member
11 months ago
Solved

Creating a new column that counts rows per month data from a different tables

Hi all,   I have three tables, REL, RE and Call Volumes. I am trying to create ttwo new column in the call volumes that shows a count of the number of REL and RE that occurred in that month/year. ...
Need Help
  • kushanNa's avatar
    kushanNa
    11 months ago

    Hi Chamari 

     

    are you looking for an ouput similar to this ? 

     

     

    If this is what you are looking for, then you do not need to creating calculated columns, you can do it using only measures for the calculations. I had to create a measure for each requirement and also a date table. I also noticed that your dates are in European format, which could be the reason why you are having issues formatting them.

    Please find attached a sample PBIX file I created for your reference.

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
11 months ago

Hi Chamari,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you bhanu_gautam and kushanNa for the prompt response. 

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

Chamari's avatar
Chamari
New Member
11 months ago

Thank you everyone for helping.

 

I managed to adapt bhanu_gautam code to makeit work for my purpose:

 

CountREL = CALCULATE(COUNTROWS(REL), REL[YearMonthNumber])
 
Thank you kushanNa also, I will look into this method also and see if it might be a suitable option.
  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    11 months ago

    Hi Chamari,

     

    Thank you for the response and confirming that the solution worked for you. I request you to please mark the post as Accept as Solution which helped you in resolving the issue, so that other community members who has similar issue will find it more easily.

     

    Thanks and regards,

    Anjan Kumar Chippa