Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Day.
I need help in creating a formula like a value based on the selected start and end date.
Like this but it is not calculating properly .Thanks in advance
Hi @pvn
How does your visual look like? Is there a relationship between the two tables?
Hi @amitchandak i have one table containing star and end date:
other having value:
so i need to calculate this value on the basis of that start and end date.
thank you
@pvn ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I think these can help
Between Dates - Dates between
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |