Forum Discussion
Solution SpecialistNeed some help with DAX
Hello experts! Need help to create a measure.
I have a table of transactions like so:
The user wants to see each week the payment could land, from ship to due date like so:
I created a date table and joined the two tables so they can pivot on week or customer, whatever the user likes.
I've tried a few measures but I can't get the value to show at each week/period. Either it puts it all all periods or only the one.
Thank you!
Think this is what I was looking for. Power BI Community
Initial results look promising. Will validate the data.
11 Replies
- parry2k
Super User
if without measure you put
bill to cust on rows
date in column
sales in values (choose sum from drop down)
it will give you what you need.
Aron_MooreMaybe but I think it would take some redesign. Currently there is only one value per date in the model. They want to see the value across every date/bucket that is possible.
- parry2k
that is ok, choose matrix visual and use fields as i mentioned and it should work.
- Aron_Moore
Think this is what I was looking for. Power BI Community
Initial results look promising. Will validate the data.
v-huizhn-msftMicrosoft Employee
Hi Aron_Moore,
Please try the solution in the thread you found. And feel free to ask if you have any other issue.
Best Regards,
Angelia- v-huizhn-msft
Hi Aron_Moore,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.Thanks,
Angelia- Aron_Moore
Still waiting to hear back from the testers.
