The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey there,
Do you know how to add a column to highlight the running total by date and by SKU ? Thanks!
Solved! Go to Solution.
I think I figured it out. The formula should be as below..
I hope I have been helpful.
Mark it as a solution if resolve your problem.
Ciao!
Any thoughts? I'm thinking I should apply sumx with earlier function by SKU and by Date...any thoughts? Thanks!
Is this what you want?
I hope I have been helpful.
Mark it as a solution if resolve your problem.
Ciao!
Sorry, it doesn't work. But thank you though.
Try:
Measure =
CALCULATE(
SUM('Table'[Demands])
DATESYTD('Datatable'[Date])
)
I hope I have been helpful.
It's more easier to help you if you upload your pbix.
Mark it as a solution if resolve your problem.
Ciao!
Thanks for your help. But it doesn't work.
It doesn't work because you don't ask if it is a measure or a calculated column. I give you a measure and you use it like a calculated column.
Oh, gotcha. thanks!
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
95 | |
81 | |
55 | |
48 | |
48 |