Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Display rows with multiples criteria

Hi, I want to have a field if "Missing Invoice Date" is selected, only show rows that have "Missing Invoice Date"  =1 , I have created Column for the 3 missing dates but I am not sure how to create ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , In case you need measure to count

 

Missing Invoice Date = Countrows(Filter('Table,'not(Isblank('Table'[PO Date])) && isblank('Table'[Invoice Date])))

 

Missing PO Date = Countrows(Filter('Table,'not(Isblank('Table'[Invoice Date])) && isblank('Table'[PO Date])))

 

Missing Shipped Date = Countrows(Filter('Table,'not(Isblank('Table'[Received Date])) && isblank('Table'[Shipped Date])))