Forum Discussion

sevens0001's avatar
sevens0001
Frequent Visitor
5 years ago

Countifs in Power BI

Hi, everyone!    I'm trying to convert a countifs formula from an excel report into Power BI. It has two date context filters and I'm having a hard time wrapping my head around the logic and syntax...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

You may download my solution file from here.

Hope this helps.

sevens0001's avatar
sevens0001
Frequent Visitor
5 years ago

Thank you, Ashish - 

 

I was able to follow how you transformed the data. Unfortunantly I can't expand my rows by the months that it's open. Too many other metrics rely on distinct agreggations on other fields in 'Jobs' table. It would also degrade the performance. I have over 4000 rows of data already with 5 other sources pulling in. Thank you though!