Forum Discussion

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

TOTALYTD Per Day Name

Hello, I am scratching my head with the TOTALYTD calculations, and it doesn't seem to be working as intended. I have a Date Dimension table, which has dates and Day Names (Monday, Tuesday, etc.) ...
Need Help
  • hnguy71's avatar
    hnguy71
    1 year ago

    Hi ExcelMonke 

    Would you be able to provide a sample dataset? And possibly with expected output?

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
1 year ago

Hi hnguy71 ,
Thanks for the suggestion, but the result gave me the same result as the 3rd screenshot (>300K per day). I even tried adding in ALLEXCEPT and ALLSELECTED functions, but they didn't help. Do  you have any other ideas?

Thanks!

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi ExcelMonke ,
I wanted to check if you had the opportunity to review the information provided by hnguy71 . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.