Forum Discussion
Resolver IPlot stock level of workload
Resident RockstarHere's another option too:
0: Add an Index column for counting later:
1. Add a new Custom Column in Query Editor to Insert all the dates between DateReceived to (EndDate or TODAY if EndDate is blank)
{Number.From([DateReceived])..Number.From(
if [EndDate] is null
then Date.From(DateTime.LocalNow())
else [EndDate]
)}
2. Expand the list to show all dates between your Date Received and Endate (or Today). Format the new data as Dates
(Index column was cut off in the screen shot)
3. Here's how it shoudl ook:
4: Gragh your data with DateList (Month) as the Axis and DISTINCT COUNT of Index as your Values.
Back2BasicsHi fhill
I have tried to do as you suggested but I can't get there. I have used the following expression:
{Number.From([nrw_datereceived])..Number.From(if[End Date] is null then Date.From(DateTime.LocalNow())else [End Date])}
as suggested, but every time I add it i'm asked to put in credentials. I do that as I normally would to refresh my data, but it gets to the end and then says that I don't have permission.
Not sure what I'm doing wrong here? I can't even view the table, once I've added the expression for the column, to expand it.
- fhill
Are you able to insert the index column, or does that fail as well? Sounds like you may need a more DAX driven solution than Power Query.... FOrrest
- Back2Basics
I could add the index column okay, it worked but I ended up taking it out as I have another column with a enique identifier so figured I could sue that.
fhillYour sign off completely threw me... as that is also my surname :smileylol: