So I have a process. If there is a date in the “JOA SENT TO MGR DT” but not in the “JOA Closed Date” then I want it counted as “in process draft”. So I created a conditional column(JOA Step 1 and JOA Closed Step 1) for both columns in Power Query and then wrote a DAX formula (In Process - Drafts) to count things.
I put them in a table just to look at my values and I am getting a 2 in some cases. I don’t know what’s going on.
1018 working draft.pbix (97.2 KB) (upload://qFL9Gn18ig2pbYxZTNlKGCepNTm.png)