Unable to create new table using DAX, pbi excel

[decarsul]

Hi there!

So i been looking for a way to make a trend view based on open tickets and plot them on a date axis that corresponds with the time they are open. I found a solution i'm wanting to test here: https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/m-p/200304#M88115

Now, i editted this suggestion to what i need. But seem to be unable to create a table in the power query / power pivot features supplied by Excel. So no i'm not using powerbi Desktop, i'm using powerbi from excel.

Can any one help me how i can create a table in power bi excel using dax?

The only option i have now generates a calendar . . . which is the option found under design ( in between start and advanced tab) on the diagram view.

[decarsul · Accepted solution]

Right so, i tinkered a bit further and atleast got rid of the error. But now i'm not getting any results :S

=CALCULATE (
        COUNT ('fact.table'[UID]);
        FILTER ( 'fact.table';
        		'fact.table'[Start] > [Date] && ('fact.table'[End] <= [Date] || ISBLANK('fact.table'[End])
         )))

[decarsul]

And . . . appearantly i was going to quickly for my computer to keep up. 

After some time, all a sudden numbers appeared!

[decarsul]

So, after reading the code, i got the idea to simply add a calculated measure to the calendar table. But it won't take my calculate as i am using more than 1 column.

=CALCULATE (
        COUNT('Table'[Task Number]);
        AND('Table'[Startdatum] <= Agenda[Date]&&
                    'Table'[Einddatum] >= Agenda[Date])
                )

Any idea?