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.
Hi all,
I have the amount by month, but I need to have the amount by week too. So I thought creating a measure that gives me the daily amount so I could have a line chart showing the amount by month with the ability to drill down by weeks.
Can you help me with a dax measure that gives the total amount by day?
You can see the something is wrong with my measure as I'm the values by the 1st week of each month only.
@ROG , refer if my blog can help
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-...
Thansk @amitchandak
I've tried this, but it's not shwoing any values by days, only by the 1st day of the month. Why is that?
Date comes from my Calendar table and below is the budget table.
Below is my model.
Thank you so much!
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |