Hey there, thanks for watching! I've catalogued all of the datasets/reports in this onedrive folder:www.patreon.com/posts/demo-files-52538104 It's currently only available to patrons for a small fee, however once you sub, its lifetime access
This is POWERFUL! Thank you kindly for sharing. Looking forward to more. If i could request a video, only if u have time, i have a unique challenge where i have a typical budget spreadsheet, i have to unpivot, whiich puts month dates in each row - perfect - but then i need to sum the totals for each month, and add an addiitional amount in an adjacent using firstnonblank, but i only need to add this amount the total of the sum'ed amount. If that makes sense? Welcome to my nightmare. 🤭
Hi, I want to use the Year that the user select from the Year filter, how to use the selected Year in the DATE function? for example from the report user select Year filter = 2023 how to pass the selected Year to the function DATE below? Date Between = DATESBETWEEN('Calendar'[Date], DATE(Year, 1, 1), DATE(Year, 12,31))
Hello Fernan..!! , at 9:48(DATESBETWEEN as a relative) the calculation of Last 3 days measure was quite good , but when I cross check the ‘Total sales last 3 days’ values by each row in the video the values are not matching(Except for first 3 rows…i.e. £440 + £1863 + blank = £2303.4 ) Can you please clear this query for rest of the rows ?