Forum Discussion

decarsul's avatar
decarsul
Icon for Helper V rankHelper V
6 years ago
Solved

Unable to create new table using DAX, pbi excel

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.

Help
  • decarsul's avatar
    decarsul
    6 years ago

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

3 Replies

  • decarsul's avatar
    decarsul
    Icon for Helper V rankHelper V
    6 years ago

    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? 

  • decarsul's avatar
    decarsul
    Icon for Helper V rankHelper V
    6 years ago

    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's avatar
      decarsul
      Icon for Helper V rankHelper V
      6 years ago

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

      After some time, all a sudden numbers appeared!