where i can practice, more scenarios in dax for every function @curbal
@CurbalEN
2 жыл бұрын
Here : m.kzitem.info/door/PLDz00l_jz6zym_YP8ZW11o52niGfCP8pN Or here: curbal.com/25-days-of-dax-fridays-challenge
@shivasai25
2 жыл бұрын
@@CurbalEN Thanks a lot for the insightful info
@pilarbaldominos2505
2 жыл бұрын
Fantastic video… perfect for the people migrating from excel :) I struggled with these issues at the begging of my journey. I love to watch your videos to find inspiration when I face DAX challenges! Gracias Ruth!
@CurbalEN
2 жыл бұрын
Gracias a ti Pilar!!
@SergioGonzalez-pu7wh
2 жыл бұрын
Just implemented this one. It worked perfectly! Thanks
@CurbalEN
2 жыл бұрын
Bravo!!
@roywilson9580
2 жыл бұрын
Thanks for the video. Grabbing the value in the previous row is something that I always find that I have trouble remembering how to do. One day maybe I will learn how to do it without having to look it up!
@CurbalEN
2 жыл бұрын
😂😂 Same here depending on how to grab it!
@TheKermit2110
Жыл бұрын
apologies - i came for the advice but i stayed for your voice. Terribly ashamed to say that biology took over - u have the sexiest voice in the power platform. There, i said it!
@MacarServicios
2 жыл бұрын
Muchas Gracias Ruth!!, Excelente video
@CurbalEN
2 жыл бұрын
In placer!!
@elvinlee5346
2 жыл бұрын
Thanks for sharing. However, when I follow the same process and try to simulate the case, what I got the result column is identical to the total column? Not sure where I'm doing wrong
@MrRagerrrr7777
2 жыл бұрын
what if your dealing with financial year? how do you do the date add? thanks! please help
@jishnusachidanandan5866
Жыл бұрын
I want to apply same scenario but not for date. Its a different period but have a Age column with numeric datatype. Please guide how to solve a scenario with a Age column instead of date where we cannot apply dateadd.
@visheshjjain
2 жыл бұрын
Just for the portion where you wanted to calculate the mesasure when there is a country present, do think HASONEVALUE() or ISINSCOPE() would have worked better?
@vyasrahul
2 жыл бұрын
Gotta try this with my fiscal calendar, which starts in November. (Dateadd -1, year) messes up my visuals when I put the fiscal calendar in the slicer.
@koteswaribapatla8075
2 жыл бұрын
Hi,i have one scenario like i have a slicer with (units,thousands,millions )when i select millions value in bar chart and what charts i used it should display with single decimal value and when i select units and thousands value should be with out decimals.i had written dax formula with format function i am getting error like "text can not convert to number format" so please advise if any one can provide solution.
@yagodde
Жыл бұрын
And if my dates are not the same? how would i solve that in DAX?
@datareggibi
2 жыл бұрын
Awesome! Thanks @curbal
@CurbalEN
2 жыл бұрын
My pleasure :)
@venkatareddykummitha5863
2 жыл бұрын
Do a videos on SELECTED VISUALS IN Bookmarks please.. I am really confused while doing this work on whenever
@ManiV1991
2 жыл бұрын
Great learning from you.Missed these many years.Thank you. Could you recommend me a methadalogy where I can follow to learn things in PBI..i am a beginner
@CurbalEN
2 жыл бұрын
I am working on it , stay tuned !
@udusegbe
2 жыл бұрын
Great video - very handy & practical! Thanks. Question. Using DAX, how would you handle calculating previous row for work week days i.e. previous value to get Friday if one is on Monday?
@CurbalEN
2 жыл бұрын
Using Day instead of year might do it, try it
@udusegbe
2 жыл бұрын
@@CurbalEN Thanks for taking the time to respond. Appreciate 😀 My point centers around how time intelligent functions work - they expect uninterrupted 'daily' dates, including weekends. So I created another data table with work days values only (excluding weekends), loaded into the model and connect to the Calendar table. I also changed 'year' to 'Day' in the Prev row DAX calculations. As expected, the DATEADD referenced Sunday as previous day if you were on Monday. But because there is no value on Sunday, it returned blank. My question was how one could reference the last given value as previous (in this case, Friday's value) in your video above? I have a feeling you've probably covered this in one of your videos. Let me check 😀
@tanayrajjhagadiawala8790
2 жыл бұрын
You are doing an awesome job. I got so many solutions from your videos. But I am stuck at one point. I am creating a sales report for my company. for that each month I get txt file. The size of each file is around 150mb. For that, I also have to combine old data. data for the years 2019,2020 and 2021. now the thing is, I also get patient data. now, I want to give the patient's id. Based on the patient's name and DOB. The challenge is Patient's id should only be given if that patient coming for the first time. if the patient comes again after two years, an old id should be given. One more condition; all patient information should not be included in a data model. I have to delete all columns except the patient's id. How can I do this? please help me. I am stuck at this point for while. Thank you in advance. Keep going.
@tanayrajjhagadiawala8790
2 жыл бұрын
I got the solution from your video only:p kzitem.info/news/bejne/mHmnvpiJfoBjnmk Thank you!
Пікірлер: 34