MTD,QTD,YTD Slicer for Actual VS Targeted Hours

[vchauhan011]

Hello Everyone,

I want to create a MTD,QTD,YTD Slicer which can filter Actual and Targeted Hours. I created MTD,QTD,YTD table using DAX and made connections between that table and my primary data source (which is a PowerBI dataset) using a bridge table. It is working for actual hours. However I am struggling to make it work for the targeted hours.  Targeted hours are summarized by months in the data source. that data source does not have a date column. targeted hours data source looks something like this table.  Is there a way I can make some changes in the targeted hours table in the powerBI and make a relationship between  the bridge table and targeted hours table?

Months	Hours
July	42342
August	86785
September	25656
October	99658
November	47476
December	63622
January	23434
February	564641
March	342422
April	324242
May	23423
June	53453

I am still new to this and I do not know if this is enough data to figure out the solution. Please let me know if you have any questions. Thank you in advance! 

[vchauhan011]

@amitchandak. This did work! Thank you very much for sharing this solution with me. really appriciate your help.

[amitchandak · Accepted solution]

@vchauhan011 , This what I usually do, I assign a date like

Date = "01 " & [Month] & " "  & [Year]

Date = "01" & [Month] & " 2021"

Refer to my article and blog

Power BI 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-...

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

https://www.youtube.com/watch?v=yPQ9UV37LOU