Forum Discussion
ashaikh
Helper III
Helper IIIrunning total
Hello All, I have one scenario which I am trying to do I hava table having ticket data. Ticket No | Data Create | Day| Ticket allotted per day
1 |2017-08-01 | 1 | 26
2 ...
Let me know if this solves your problem. I find it easier to write the code based on your data:
https://www.dropbox.com/s/b2iv4gtmoofx5kb/Running%20total.pbix?dl=0
Have fun with DAX!
Alberto Ferrari
http://www.sqlbi.com
ashaikhHelper III
Helper IIII am not getting the desired result.
What am I getting is same value for throught out the days. i.e. 26
ImkeF
Community Champion
Community ChampionMake sure to drag the date-field from your calendar-table into your report.
If your measures reference 2 different tables, you need a table with a date that is connected to both of them. Only date-fields from this table will lead to correct results in your report!