Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
decarsul
Helper V
Helper V

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.

1 ACCEPTED SOLUTION
decarsul
Helper V
Helper V

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

View solution in original post

3 REPLIES 3
decarsul
Helper V
Helper V

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

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

After some time, all a sudden numbers appeared!

decarsul
Helper V
Helper V

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? 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.