Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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])
)))
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!
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?
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |