Creating a chart with 2 dates to comapre entry and exit

PTIFANOU OK:

• Create a disconnected table for your months (no relationship) using an Enter Data query to just enter your month names in one column and the month number of the year (1...12) in the other column. Let's assume that you call this table "Months" and the columns are "Month" and "MonthSort" respectively
• Set the Sort By column for the first column to be your second column
• Create the following 2 DAX calculated columns in your table:

Creation Month = FORMAT([CreationDate],"mmmm")


Cloture Month = FORMAT([ClotureDaate],"mmmm")

• Create the following 2 measures:

Documents Created = 
  VAR __Month = MAX('Months',[Month])
RETURN
  COUNTROWS(FILTER('Table',[Creation Month] = __Month))


Documents Cloture = 
  VAR __Month = MAX('Months',[Month])
RETURN
  COUNTROWS(FILTER('Table',[Cloture Month] = __Month))

• Create a bar chart visual
• Place Month column from your Months table into the X-axis field well
• Place the two measures into the Y-axis field well

Hi,

I suggest having a calendar table like below.

One active relationship and one inactive relationship.

And then use USERELATIONSHIP dax function when using inactive relationship.