Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

GroupBy function to include zero values

Hi, I am looking to group my data of InvoicedQty by Yearmonth. I need the grouped sum data to include zero values. I have data in the following format:   YearMonth InvoicedQty 2019/01 1...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
4 years ago

Hi Anonymous ,

Do you want to create this in the power query side?

Thank you

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Dinesh_Suranga 
Perhaps rather as DAX, but which ever way works best.
Thank you

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Continued Contributor
    4 years ago

    Hi Anonymous,

    Please try this first.

    Right click on YearMonth tick show item with no data.

    If it does not work, will go to the next step.

    Thank you.