How to achieve Targeted value based on 1st day of month profit in power bi

[arvindyadav]

Hi Team,

How to achieve Targeted value based on 1st day of month profit in power bi?

Suppose I made $42000 on 1st Dec 2019 and I want to achieve the target on this month $2M($2000000) so how can I do that in Power BI. Basically, what is the next profit value of every next day in the table?

Based on the previous day.

for more info please check the image

Thanks,

Arvind

[v-joesh-msft]

Hi @arvindyadav ,

You can create measures similar to the following:

Remaining target =
VAR Target = 2000000
RETURN
    Target - CALCULATE ( SUM ( 'Table'[Profit] ), ALL ( 'Table' ) )

Averagedayprofit =
VAR Target = 2000000
VAR _noblankrow =
    COUNTBLANK ( 'Table'[Profit] )
RETURN
    DIVIDE (
        Target - CALCULATE ( SUM ( 'Table'[Profit] ), ALL ( 'Table' ) ),
        _noblankrow
    )

 Results are as follows:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Eb_bOOtDrbBNgmewA1...

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[arvindyadav]

Hi @v-joesh-msft ,

If I don't have future dates entry it also reflect the value?

[arvindyadav]

Hi @v-joesh-msft ,

Not getting what I needed here 1st-day value is $70306 and I need one more column that's name is Projected Gross Revenue so based on my 1st day of the month I want to know that what is 2nd-day value, 3rd-day value,... so on last day of month value so that I can reach 2M gross revenue.

Basically I want as :-

So projected Gross revenue is based on 2M targets and 1st day of the monthly gross revenue.

Thanks,

Arvind

[v-joesh-msft]

Hi @arvindyadav ,

I'm a little confused by your description. 57217.25 is not reflected in your sample data. Is there any relationship between this value and other data? Could you please share your calculation logic?

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[arvindyadav]

Hi @v-joesh-msft ,

So Sorry the 1st-day value is 70306 which comes from a dataset and the projected gross revenue is based on the targeted and 1st-day value of the month. So how to find 2nd or 1st-day value to till last day projected gross revenue to achieve targeted value i.e, 2million in the month.

where projected gross revenue is an assumption by me. Is there a way to get projected gross revenue based on 1st-day value and targeted value so that we can know how much revenue we achieve day by day based on the actual gross revenue.

Thanks,

Arvind