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?
@EnterpriseDNA
3 жыл бұрын
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/
@Don-ec3vc
3 жыл бұрын
@@EnterpriseDNA Alright, Thanks!
@hamzamottali3567
3 жыл бұрын
thank you sam, i love your teach way, can you compare between tow months in the same year ?
@EnterpriseDNA
3 жыл бұрын
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 KZitem 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/ kzitem.info/news/bejne/0Z-lsHWbp3p2gJw kzitem.info/news/bejne/koZvn6adcpNnmKg forum.enterprisedna.co/
@Tat-cx1lr
3 жыл бұрын
Merci pour ce partage. Remarque il y’a une erreur sur votre rapport Q1-2020 vs Q1-2019
@mohdmuzammil3059
3 жыл бұрын
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
@EnterpriseDNA
3 жыл бұрын
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/
@bhavdipgediya5830
Жыл бұрын
🔥🔥🔥🔥🔥
@EnterpriseDNA
Жыл бұрын
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!
@soflute1
3 жыл бұрын
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.
@EnterpriseDNA
3 жыл бұрын
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/
@surafeltilahun7404
3 жыл бұрын
love this man
@EnterpriseDNA
3 жыл бұрын
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: kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA
@khan.naved1
4 жыл бұрын
Thanks sam❤️
@EnterpriseDNA
3 жыл бұрын
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: kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA
Пікірлер: 16