Forum Discussion

CROforce's avatar
CROforce
Helper I
9 years ago
Solved

Count by Date using filters

Here is my sample data table called “observation” :   I have also created new Table called “Calendar” in Query editor which contains Date that goes from 9/30/2015 until today and I also have ...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    Rather than custom formulas, have you tried the "Group By" funcitonality  within the query editor?

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago
Can you post some sample data or the PBIX for us to play with?
CROforce's avatar
CROforce
Helper I
9 years ago

I have just figured it out... I had to use ALLSELECTED in my formula instead of ALL

Net OPEN = 
    CALCULATE (
        SUM ( 'Open'[Open] ) ,
        FILTER ( ALLSELECTED ( 'Open' ), 'Open'[Index] <= MAX( ( 'Open'[Index] ) )
    ))