topic Re: Unable to create new table using DAX, pbi excel in DAX Commands and Tips

Unable to create new table using DAX, pbi excel

decarsul — Wed, 27 May 2020 11:53:34 GMT

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.

Re: Unable to create new table using DAX, pbi excel

decarsul — Wed, 27 May 2020 13:52:07 GMT

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?

Re: Unable to create new table using DAX, pbi excel

decarsul — Thu, 28 May 2020 07:24:10 GMT

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]) )))

Re: Unable to create new table using DAX, pbi excel

decarsul — Thu, 28 May 2020 08:06:31 GMT

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

After some time, all a sudden numbers appeared!