Last seen: Aug 26, 2025
You can add a TimeLine to the pivot chart to control the dates displayed on the X-axis. And to include the deadline marker you need to create a table ...
Yes please, add more information. For instance, upload a file with examples of what you are dealing with and the desired results.
Ah. forgot to mention that extra column. It's to enable the filter function to pick-up only visible rows fro the data table when you have made a selec...
I took the liberty to change your set-up slightly. See attached and let me know if this works for you. Had to remove the pictures as the file is to...
I've formatted the data table as a structured Excel table so that you can use table/column references. Then, a formula like this in U4 on the Summa...
How strange. Received the same messages when I opened my own file. Saved it under a different name and then I could open it without errors. All seems ...
As far as I could determine, adding the date field the did exactly what it was supposed to do. That is, return the total contract amount, the revenue ...
Understood! Thanks for the feedback. In PQ there are indeed many instances where you see that, for example, a preview is based on the first 1000 recor...
I've added two calculated columns that determine the Quarterly groupings. One for the regular calendar quarter and one for the quarter that is shifted...
I trust you have done what you can but it's difficult to diagnose the problem without seeing the data. How do 'dbo_invoiceitems' and 'invoices' look l...
Hi Paul, I've attached a file containing an example of how you could calculate the hourly groupings you describe. I left the intermediate steps in ...
Don't really understand what you want to achieve. Quite difficult to see what's going in your model based on screenshots alone.
I formatted both table columns based on the formats displayed for the first 4 rows. Amount as a two decimal number and Date with a custom format "d/m"...
Could you upload your file, anonymized of course? Otherwise it will be difficult to help.
I believe you made a small typo when you wrote the measure. =CALCULATE(SUM(Units[Units]),DATESINPERIOD('Calendar'[Date],MAX(Units[Date])-3,MONTH)) ...