Forum Discussion

JB17's avatar
JB17
Frequent Visitor
1 year ago
Solved

Total Per Month

Hi, I need help with creating DAX for the following:   Instead of showing the value for each status per date per month, I need to show the total status per month in the desired result. thank...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, JB17 

    Based on your information, I create a sample table:

     

    Then unpivot columns, like this:

     

    Select Close & Apply. Create a table visual, put the date, status, and values in the table, and then date selection to leave the month. Here is my preview:

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

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

vivek31's avatar
vivek31
Resolver II
1 year ago

HI JB17,

first you shoud format your status column and create a new status column in table 

new status = FORMAT('Table (6)'[status],"MMM-yyyy")


and create formula this type formula 

per month Action = SUMX(VALUES('Table (6)'[new status]),SUM('Table (6)'[Action complete]))
per month Deferrd = SUMX(VALUES('Table (6)'[new status]),SUM('Table (6)'[Deferred]))

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you