Forum Discussion
Helper Iworking day, total working day, running total
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.
Helper IThis is what i am getting. Am i doing something wrong?
TestColumn = [ColumnMT]/RELATED(DimDate[RWkday])
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.
- prakashacharya
Sure..i will wait for you. I have no idea how to make it happen. :(
- Chihiro
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.
- prakashacharya
Perfect!! thank you so much.
- prakashacharya
One thing i noticed that the numbers in the chart do not match. It works when you put date (day) in the Axis.
- Chihiro
That's because you wanted to chart based on Working days.
Since it's just integer and each month there could be duplicate...
I suggest you use actual date column for axis.
Edit: Or alternately create another column, to plot... Ex. Month + Working days.
- prakashacharya
Month+Working Days is not going to create duplicate values? How does that work?