How to show monthly and YTD

[locle90]

Dear All,

I have 1 idea to show the buget,month and YTD(arcminute) on power bi.But i tried to do a lot of way and fail.

Could you give me advice how to show it?

Ex : Month i can choose on sliser.Buget is fix for all year.

[locle90]

Hello 

I have an excel file for target next year. And also have a report every day for actual sales.

I want to make the report with 4 collum by month selected.

1. Brand

2.Target fix for all year (%)

3. Actual (%)

4. Average(%) from Jan to the month selected.

Ex: if I select May so (1) and (2) is fix. (3) will show actual in May and (4) show average from Jan to May.

Thanks

[amitchandak · Accepted solution]

@locle90 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if my blog can help

#PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...
Appreciate your Kudos.