User Profile
rosiebilton23
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Order months in financial year in table
Hi all, Im sure this is easy to fix but I am at a loss. See screenshot below, my table is is showing January at the front of the table, rather than after Demeber. I have tried a number of ways to creat a month and year column but nothing seems to be working. FYI our financial year is July-June. The transactions on this report have a date against them, in this format 01/01/2024. Any help would be greatly recieved. Thanks RosieCumulative total incorrect when added to chart
Hi all - hope you can help! I have created a measure as per below to get a running total or cumaltive sum of GP. I am simply summing up each month as we go along, filtered by only the months that appear on the actual sales. Cummaltive Actual GP = CALCULATE(sum(udvPowerBIJCSummaryV2[GP]), DATESYTD(MonthTable[Month]), FILTer(udvPowerBIJCSummaryV2,udvPowerBIJCSummaryV2[Mth] >= udvPowerBIJCSummaryV2[Mth])) This works fine. Except, when I put this into my graph, the first two months do not show? any ideas why? The only date filter on the page is a slice which includes the dates the graph is not showing! The actuals are there in the graph lines, so I cant understand why they dont appear on the cumaltive line? The circle is my issue, why isnt the yellow line going up to there? Hope this enough info! Thanks Rosie
