Forum Discussion
Power BI Data Shaping
Hello, I'm havnig an issue creating a metric in Power Bi. Im trying to capture when two fields are blank and the Est. Close date was in 2017. I tried to accomplish this by creating a new column, ...
Hi mikep7521
since teher is no sample data/ expected result is given, am making a best guess and something like this may help you.
2017 Total # of Processed Files = CALCULATE( COUNTROWS(Installment) , FILTER (Installment, ISBLANK(Installment[Pool__c]) && ISBLANK(Installment[Portfolio__c]) && RELATED (Installment[Est_Close_Date__c].[Date]) < DATE(2018,1,1)
Thanks
Raj
There is sample data in the comment above