Forum Discussion
dbrandone
Helper IV
Helper IVHelp. Numbers are not adding up and I do not know why
In the picture below, you can see the measure that wrote for Consent rate Last Week. In the matrix below, I have year, months and week number in the row part and then columns. The consent rate is sim...
dbrandone I did invent a DAX week number column that does not reset at the end of the year called Sequential: Sequential - Microsoft Power BI Community
dbrandoneHelper IV
Helper IV
I ended up trying this and it seemed to have worked and should keep steady this way, but I am still interested in the reason my Week number column isn't functioning properly or if there is an issue with one of my tables.
Greg_Deckler
Community Champion
Community Championdbrandone I did invent a DAX week number column that does not reset at the end of the year called Sequential: Sequential - Microsoft Power BI Community
- dbrandone
Thanks!! I already created a new column off of your column code and it is functioning well.