Hi, I am trying to create a cumulative value for each category as pictured. I tried below DAX but its not giving me cumulative but a weekly data again. " Cumulative C&I Earned H...
Hi Team, Looking for a little guidance. I'd like to calculate MTD revenue using week numbers that are tied to a month So for example: Month 1 = week 1/2/3/4 ...
Unfiltered: Filtered: The task at hand is simple, take the 2025 values (Food Revenue, Beverage Revenue, etc.) and subtract the 2024 values from the correlated field (first screensho...
HI. I have the following calculation - % Change YOY = CALCULATE(DIVIDE(SUM(Dodeca_Financials[YTD]), [LY]) -1) which works accurately. I also have a simple viz to display my re...
Hello all, again, I need help because I am totally lost: with the help of this forum, I was able to create this chart, and there is now only missing, to show the deltas between the periods (-15...
Hello, I have a little problem, where I cannot seem to find the answer to. I have one table with all the Information in it, and in that Table is a Column, that has TRUE or FALSE v...
Hope this is easy to solve: I have this expression that works fine: VAR KPI Incr good % Total = VAR Excl_Casuals_MOM = IF(HR_data[Headcount Excl Casuals month on month]<0,1,0) VAR Apprenti...
Hope I can describe this problem correctly! I have 2 tables, not joined to each other: FACT Table Location Category A Category B Value 1 A Z 51 1 B X 100 2 A Z 56 ...
Hello, I am trying to create a measure to calculate teacher turnover within the table below. Each teacher has a unique research ID, and the file contains 9 years of data. I essentially...