Incidents wise i need to display on monthly

[sreddy47652]

Hi Team, I need to display in visual latest month how many P1, P2 P3 P4,P5 tickets closed on card level, i need one calucalted column to display below like image1(here i am using text box level static but i need dynamic). Please help me to get DAX.

[JoeBarry]

Hi @sreddy47652 

How is your data set up? Does the visual use the Year/Month  column from a date table or the table with the Incidents? If the Incident table has a date column in a normal date format dd/mm/yyyy or mm/dd/yyyy then do the following

• Make a copy of the visual and change it to a card.
• In the filter pane on the right of the screen add the date column from either the date or Incident table
• Click on Filter type
• Choose Relative date
• choose "is in this "
• Month
• Apply filter

This will show you the current month, this also dynamic, so when it's September, it will show Septembers numbers instead.

Thanks

Joe

If this post helps, then please Accept it as the solution