Forum Discussion

clim2f88j's avatar
clim2f88j
Frequent Visitor
3 years ago
Solved

Monthly Calculation Table

Hello everyone, i’m a new Power BI user so i apologize for my entry level question.   I need to create a table that gives me the separated total amount of “issues” per month and totals. This data i...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi clim2f88j 

    In order to achieve your goal, you can:

    Preparing data in PQ is the first step:
    Add a column with the month names

    2. Add column with concatenating string "issue" to your issues:

    after it press "close and apply"
    3 . Create a measure to count rows for issues with Dax: 

    ISS_QTY = count('Table'[ Issue ])

    4. Create Matrix with , months in rows, issues on columns and your measure on values

    Link to sample file 

     

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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Create a Calendar Table with calculated column formulas for Year, Month name and Month number.  Sort Month name by Month number.  Create a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table.  To your visual, drag Year and Month name from the Calendar Table.  Write this measure

Measure = coalesce(countrows(Data),0)

Hope this helps.