Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
@amitchandak. This did work! Thank you very much for sharing this solution with me. really appriciate your help.
@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
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |