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))
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
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 ?
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))
I didn’t get the average function part. Is it supposed to be dividing by the total number of days.. ..?if it’s doing where it is?
Thank you for the great video. In the calculation of last 3 days sales, how do you exclude weekend days? Appreciate your guidance.
Great explanation and very transparent!!. Thanks for sharing
Glad it was helpful!
You are a life saver! I've been looking for this! Very clear explanation and easy to follow. Thanks for sharing!
I found your videos Awesome. Can you please share the data set for every power Bi module in your channel?
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
i am getting blank values for the same formula. how can this happen
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 ?
yeah I confirm, it doesn't give us the total sales last 3 days.
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 Imran, thanks for watching! And indeed interesting challenge, it sounds like something that needs be dealt with in DAX, I'll put this on my list!