Hi Sam, In some situations you can use SUMX(FILTER(,), ), At the same time you can use CALCULATE(SUMX(, ) , FILTER(,)) Both will give the same output. When should you use which?
Hi Nathan James - Calculate table helps in Context transition that is not possible using SUMX . Also, we can add number of Filters in Calculate even from Non Related tables that is not possible using SUMX. For In-Depth DAX learning - Explore member only "Mastering DAX Calculation" course at portal.enterprisedna.co/p/mastering-dax-calculations For Complete EDNA membership, Explore portal.enterprisedna.co/
Hello hamza mottali, thank you for posting your query onto our channel. Sure, definitely you can compare between two months in the same year using the "DATEADD()" function. It's the most versatile function than the "SAMEPERIODLASTYEAR()". "DATEADD()" function allows you to make comparison between the Days, Month, Quarter and Year. We're providing few of the articles of the blog posts as well as links of some of the videos available onto our Enterprise DNA RUclips channel pertaining to this function. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful and meets your requirements that you've been looking for. Happy Learning!!! blog.enterprisedna.co/the-dateadd-function-the-best-and-most-versatile-time-intelligence-function-in-power-bi/ blog.enterprisedna.co/power-bi-time-functions-dateadd-and-more/ ruclips.net/video/pioJAenHEMg/видео.html ruclips.net/video/1P99rg9a6es/видео.html forum.enterprisedna.co/
Can you please help to understand the error which shows in quarter matrix look in 2019 Q1 sales comparison with Q1 2020 it shows different values why so, same goes with Q4 kindly respond
Hi Mohd - This is due to use of SAMEPERIODLASTYEAR function in "Sales LY". This function introduce an In-Built "ALL" context. For Q1 2019 "Total Sales", DAX only consider dates in Date Range while For "Q1 2020 Sales LY" measure, DAX consider all dates of the Q1 2019. Try by changing Slicer values and you can understand the difference. For In-Depth DAX learning - Explore member only "Mastering DAX Calculation" course at portal.enterprisedna.co/p/mastering-dax-calculations For Complete EDNA membership, Explore portal.enterprisedna.co/
Hi, Am having problem is seeing my Sales in NC on the visualization table with the Measures you used when I try the same thing i.e. Sales in "NC" = CALCULATE( [Total Sales], Locations[State Code] = "NC" ). No data is showing on my visual table for Sales in N"C" or F"L", why am I having this problem.
Hello David Omogbehin, thank you for posting your query onto our channel. Well, in our file, the formula is working as expected. It's always a little bit difficult for us to judge and provide the results without looking at the working of the PBIX file. We encourage you to please write back to us onto our Community Forum by providing the description of the problem that you're facing along with the working of the PBIX file where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Happy Learning!!! forum.enterprisedna.co/
Hi Bhavdip, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hi surafel tilahun, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Hi Naved Khan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
![ATEEZ(에이티즈) - [GOLDEN HOUR : Part.2] Preview](http://i.ytimg.com/vi/X4PfgRPBUVo/mqdefault.jpg)
Hi Sam, In some situations you can use SUMX(FILTER(,), ),
At the same time you can use CALCULATE(SUMX(, ) , FILTER(,))
Both will give the same output. When should you use which?
Hi Nathan James - Calculate table helps in Context transition that is not possible using SUMX . Also, we can add number of Filters in Calculate even from Non Related tables that is not possible using SUMX.
For In-Depth DAX learning - Explore member only "Mastering DAX Calculation" course at portal.enterprisedna.co/p/mastering-dax-calculations
For Complete EDNA membership, Explore portal.enterprisedna.co/
@@EnterpriseDNA Alright, Thanks!
Merci pour ce partage. Remarque il y’a une erreur sur votre rapport Q1-2020 vs Q1-2019
thank you sam, i love your teach way, can you compare between tow months in the same year ?
Hello hamza mottali,
thank you for posting your query onto our channel.
Sure, definitely you can compare between two months in the same year using the "DATEADD()" function. It's the most versatile function than the "SAMEPERIODLASTYEAR()". "DATEADD()" function allows you to make comparison between the Days, Month, Quarter and Year.
We're providing few of the articles of the blog posts as well as links of some of the videos available onto our Enterprise DNA RUclips channel pertaining to this function.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for.
Happy Learning!!!
blog.enterprisedna.co/the-dateadd-function-the-best-and-most-versatile-time-intelligence-function-in-power-bi/
blog.enterprisedna.co/power-bi-time-functions-dateadd-and-more/
ruclips.net/video/pioJAenHEMg/видео.html
ruclips.net/video/1P99rg9a6es/видео.html
forum.enterprisedna.co/
Can you please help to understand the error which shows in quarter matrix look in 2019 Q1 sales comparison with Q1 2020 it shows different values why so, same goes with Q4 kindly respond
Hi Mohd - This is due to use of SAMEPERIODLASTYEAR function in "Sales LY". This function introduce an In-Built "ALL" context.
For Q1 2019 "Total Sales", DAX only consider dates in Date Range while For "Q1 2020 Sales LY" measure, DAX consider all dates of the Q1 2019.
Try by changing Slicer values and you can understand the difference.
For In-Depth DAX learning - Explore member only "Mastering DAX Calculation" course at portal.enterprisedna.co/p/mastering-dax-calculations
For Complete EDNA membership, Explore portal.enterprisedna.co/
Hi, Am having problem is seeing my Sales in NC on the visualization table with the Measures you used when I try the same thing i.e. Sales in "NC" = CALCULATE( [Total Sales], Locations[State Code] = "NC" ). No data is showing on my visual table for Sales in N"C" or F"L", why am I having this problem.
Hello David Omogbehin,
thank you for posting your query onto our channel.
Well, in our file, the formula is working as expected. It's always a little bit difficult for us to judge and provide the results without looking at the working of the PBIX file.
We encourage you to please write back to us onto our Community Forum by providing the description of the problem that you're facing along with the working of the PBIX file where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful.
Happy Learning!!!
forum.enterprisedna.co/
🔥🔥🔥🔥🔥
Hi Bhavdip, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
love this man
Hi surafel tilahun, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Thanks sam❤️
Hi Naved Khan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA