The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
61 | |
51 | |
51 |