topic Re: Help in calcuation in DAX Commands and Tips

Help in calcuation

Srinivas3350 — Fri, 14 Jul 2023 12:37:08 GMT

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 as a percentage figure, and also include a graphic such as a barometer?

InvoicePercentageMTD =

DIVIDE(

CALCULATE(

COUNTROWS('Table'),

'Table'[DATE_DELIVERY_DUE] <= TODAY(),

MONTH('Table'[DATE_DELIVERY_DUE]) = MONTH(TODAY()),

NOT(ISBLANK('Table'[DATE_INVOICED]))

CALCULATE(

COUNTROWS('Table'),

'Table'[DATE_DELIVERY_DUE] <= TODAY(),

MONTH('Table'[DATE_DELIVERY_DUE]) = MONTH(TODAY())

)

The text above in bold is the rquirement i tried this dax but i am not getting value let me explain in detail

if we select a Month it should have to show from starting to current before day. Lets say today is 14th july the percentage should show from 1st 13th if i go for 15th jly it should show 1st to 14th and can any one suggest me to show this visual in a good way

Thanks in advance

srinivas

Re: Help in calcuation

lbendlin — Sun, 16 Jul 2023 13:54:23 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Help in calcuation

Srinivas3350 — Mon, 17 Jul 2023 08:00:21 GMT

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

Re: Help in calcuation

Srinivas3350 — Mon, 17 Jul 2023 08:00:54 GMT

Hello if you need more info let m know

Thanks

Srinivas

Re: Help in calcuation

Srinivas3350 — Tue, 18 Jul 2023 13:27:06 GMT

hello let me give you the formula
invoiced GBP (delivery due date upto 1st july to current date/orders GBP(delivery due date upto 1st july to current date

Re: Help in calcuation

lbendlin — Wed, 19 Jul 2023 00:57:15 GMT

Unfortunately none of this helps. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.