Budget Value for each month

[Mannai]

i have a budget dataset : example => 02-2022 budget : 200 i want to show the value of the budget for the month in the slicer 

Note that this dataset is connected to date table with a no active relationship

[PaulDBrown]

I take it the Date table has a period column with the values in the date column of the budget table? If so, you can use any field in the slicer. For the prupose of this example, If simply created a period table for the slicer.

You need to create a measure to use as a filter for the visual as follows:

Month Budget =
COUNTROWS (
    INTERSECT ( VALUES ( 'Period Table'[Dates ] ), VALUES ( BudgetTable[Dates ] ) )
)

 I've attached the sample PBIX file

[amitchandak · Accepted solution]

@Mannai , You should create a date and join using month year

Date = Date(right([Dates],4) ,left([Dates],2),1)

or create a measure like. but have date in the table 

new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = mainx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Budget]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

refer if needed

Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-...

[Datagulf]

Please explain your query. I am having a hard time understanding it.