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.
I have four tables: Sales, Budget, Territory & Calendar
Sales captures sales in a retail store by item (may be hundreds of transactions per day)
Budget is a budget for sales by day (one budgeted amount per day)
Calendar is a calendar lookup table
Territory is a lookup table for each store's location
My budget includes a day type category which is important for filtering.
I have several measures that sum sales out of the Sales table but when I try to add the day type it doesn't display correctly. Is it because Budget only has one entry per day and the Sales table may have hundreds of entries per day? How would I correct this?
Thanks!
Solved! Go to Solution.
Hi,
In the Calendar Table, create a Day Type column and drag that column in your visual.
@Anonymous the reason you are not correct value coz "date type" from budget doesn't filter sales what you are trying to achieve and what is goal here?
You have incorrect and correct screen shots but does't tell what you are after.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |