User Profile
sdukes
Helper I
Joined 6 years ago
User Widgets
Contributions
Re: calculate the percent difference between two paychecks
ryan_mayu, this is my current data with implementing your solution above: but if I filter the right 'Facility' column(using either filter or slicer) to equal 'Be..', the 'days from previous' column keeps the fixed value it has in the row: instead of, for example: row 1: blank row 2: jan22-jan8=16 row 3: feb5-jan22 =14 my goal is to have the facility filter apply to the code you wrote above, and it recreate the column with the current date difference..Visualize by Month and Week Number
Here's a fun one - created a Dax calendar using CALENDARAUTO(12) Added a column using: Month = FORMAT(DatesDAX[Date], "MMMM") Added a column using: WeekNum = WEEKNUM('DatesDAX'[Date].[Date]) Put them into a hierarcy to get the following visual: The only issue is that because the week numbers exist in both months - it's doubling the data for those crossover weeks(27,31,36). Any ideas how I can clean this up? Thank you!Agrupa los datos que faltan
Hice un informe hace un poco, e hice mucho trabajo de piernas agrupando ciertos elementos para analizar mejor los datos. Se hizo una actualización a la hoja de cálculo original - se agregaron un par de elementos. Por alguna razón, estos nuevos elementos no aparecen en la herramienta de agrupación! Se amontonan en la categoría "otro" cuando selecciono "Incluir otro grupo", pero cuando no están seleccionados, ¡no están en la lista! parece un error, pero cualquier sugerencia que no me involucre a empezar de nuevo... son muy apreciados. ¡Gracias!Groups missing data
I set up a report a little bit ago, and did a lot of leg work grouping certain items together to better analyze the data. An update was made to the original spreadsheet - a couple items were added. For some reason, these new items aren't showing up in the grouping tool! They get lumped into the 'other' category when I select 'Include other group' but when deselected they're not in the list! seems like a bug, but any suggestions that don't involve me starting over... are greatly appreciated. Thanks!
