Forum Discussion
Srinivas3350
Helper II
3 years agoHelp in calcuation
Hi Can anyone help me in this DAX i tried something but it is not working properly calculate the percentage value of deliveries due month to date which have been invoiced. Please can you show this a...
Srinivas3350
Helper II
3 years agoHi
| Delivery_Due_date | Invoiced_date |
| 02/07/23 | 31/05/23 |
| 03/07/23 | 01/07/23 |
the above dates are in table and we are having date table the relation detween these table invoiced date to date and now the requirement I got is This figure needs to calculate the percentage value of deliveries due month to date which have been invoiced, so that the Shipping team can see how we are performing against the orders that should have already been shipped so far this month (based on due dates).
and they asked to show this in a percentage figure, and also include a graphic such as a barometer?
If you have any suggestions to visualize in a good way let know
| year | Month | date |
| 2023 | july | 01/07/23 |