Тёмный

DAX HASONEVALUE Function 

Goodly
Подписаться 92 тыс.
Просмотров 13 тыс.
50% 1

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog/

Наука

Опубликовано:

 

30 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 34   
@enocharthur4322
@enocharthur4322 2 года назад
It's amazing how well you're able to simplify things like this. You're a Goat!!! Thanks
@letsexcel5579
@letsexcel5579 Год назад
I'm now feeling bad for not finding you all these days. Fantastic Explanation 😊
@sixtyfiveroses2968
@sixtyfiveroses2968 2 года назад
I've just started learning DAX this week, but this was very well explained that even I understood it. Thank you very much for this. Subbed!
@joaorataoo
@joaorataoo 3 года назад
Congratulations. Again very well explained and clear. Keep up the great work.
@rameshkandi
@rameshkandi 3 года назад
Thank you for your knowledge sharing 👍
@nivethav7951
@nivethav7951 3 года назад
Clear Explanation. Thank you.
@sayi77
@sayi77 8 месяцев назад
excellent explanation as always
@vikramkukkadapu9761
@vikramkukkadapu9761 2 года назад
awesome man. really very helpful to me. Pls.. do videos like this
@mohamedchatar4393
@mohamedchatar4393 2 года назад
Great explanation thank you ! i've become addicted to your videos because of your way of simplifying things !
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Haha.. thanks Man. Hopefully this addition serves you well. 😁
@killerof21121989
@killerof21121989 3 года назад
Thanks!
@wayneedmondson1065
@wayneedmondson1065 3 года назад
Hi Chandeep. Thanks for this quick lesson. Very well explained and interesting. Thanks for sharing. Thumbs up!!
@GoodlyChandeep
@GoodlyChandeep 3 года назад
Thanks Wayne for watching all my tutorials :)
@jagans6409
@jagans6409 Месяц назад
sir, thank you for the video!! can you please explain from where the Total appeared in the visual? Is 'Total' calculated by the Visual or is it already there in the data file.
Год назад
wow I loved your channel... You just got a subscriber!
@GoodlyChandeep
@GoodlyChandeep Год назад
Welcome aboard!
@ArifulIslam-gs6uy
@ArifulIslam-gs6uy 3 года назад
Very Nice
@ardenzhuo9351
@ardenzhuo9351 3 года назад
Thanks for this great video! but one question, could you kindly explain why sumx(values) is required/how do we read that portion? if(HASONEVALUE('Country Only'[Country]),[Q1 Shipment Amt US$],sumx(values('Country Only'[Country]),[Q1 Shipment Amt US$]))
@44.7b.kaharaditya6
@44.7b.kaharaditya6 3 года назад
Very useful formula, thanks
@GoodlyChandeep
@GoodlyChandeep 3 года назад
Glad it was helpful!
@joaorataoo
@joaorataoo 3 года назад
I would like to ask you a question regarding the use of the Matrix visual. As an example use the Matrix that you used in your video. You have the Year and the Month. Suppose I want a partial total per Year/Month, but not the Year/Total, nor do I want the word Total to appear. thanks
@GoodlyChandeep
@GoodlyChandeep 3 года назад
Hi Joao, Is there any logic for Partial Total ? Partial for what period ? If you can help me understand the problem, I can look into it :)
@joaorataoo
@joaorataoo 3 года назад
​@@GoodlyChandeep In this video by Curbal, she explains how to show the Total without showing the subtotal. What I want is the exact opposite, showing the subtotals without showing the grand total. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-58a2rIV2nYg.html
@veera8853
@veera8853 7 месяцев назад
Can you explain Combination of Hasonevalue and allexcept
@thanomnoimoh9299
@thanomnoimoh9299 2 года назад
Best describe ever
@GoodlyChandeep
@GoodlyChandeep 2 года назад
Glad you like it! 💚
@SamehRSameh
@SamehRSameh 3 года назад
How can i add hasonevalue with distict count Evey month distinct count but in total return avg all months
@usmansharifshaik1187
@usmansharifshaik1187 2 года назад
sir, could you provide powerbi file for this hasonevalue video? i need to know how did you put year and month in a table at 1:20 ? pls let me know sir. i want to know. thanks in advance.
@deepag805
@deepag805 2 года назад
Bro explanation is good .unable to catch you..too fast
@momosy9413
@momosy9413 8 месяцев назад
How to contact you to take yours courses
@GoodlyChandeep
@GoodlyChandeep 8 месяцев назад
goodly.wordpress@gmail.com
@venkatareddykummitha5863
@venkatareddykummitha5863 2 года назад
How to rectify wrong values at the total level in a measure.
@sravankumar1767
@sravankumar1767 3 года назад
Has one value can only use in months and years or any other
@GoodlyChandeep
@GoodlyChandeep 3 года назад
You can write it on any column of a table. I used Months as an example.
Далее
DAX ALLSELECTED Function
17:35
Просмотров 13 тыс.
Related and RelatedTable in DAX
8:48
Просмотров 53 тыс.
Context Transition in Power BI and Tricky Examples
15:06
Distinguishing HASONEVALUE from ISINSCOPE
11:00
Просмотров 23 тыс.
DAX KEEPFILTERS Function
8:01
Просмотров 9 тыс.
Новодельный ноутбук Pocket386
1:16:17
How to Soldering wire in Factory ?
0:10
Просмотров 6 млн