Forum Discussion
prakashacharya
Helper I
Helper Iworking day, total working day, running total
Below is the link to powerbi file. i need a big help from you..geniuses Need following columns or measures ColumnMT= MTD running shipped_amount Working day (for example for Feb 1 2016, working ...
Here. Check the updated file with added measures etc.
https://drive.google.com/open?id=0B-p4nPyEKzR1X05uVTV4bW9USUk
I'm still not certain what you want to show in the chart.
I'd suggest you go through each line carefully and verify that calculated values are what you wanted. If not, you'll want to give at least few samples so that either I or anyone else helping you can verify their solution.
prakashacharyaHelper I
Helper IThis is what i am getting. Am i doing something wrong?
TestColumn = [ColumnMT]/RELATED(DimDate[RWkday])
Chihiro
Solution Sage
Solution SageYou shouldn't devide measure by column. You should create another measure to devide it by.
I'm bit busy right now with work. I'll try to look at later it if you haven't solved it by then.