Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI

Поделиться
HTML-код
  • Опубликовано: 25 июл 2024
  • In this tutorial, we review how you can work out the last value from a particular dimension in a table in Power BI.
    This is quite a unique insight but a relevant one from many pieces of analysis that you might require in Power BI.
    We work through examples of the MAXX and FILTER functions. These are two important functions in the DAX language that can be used in many situations to extract very interesting insights from your data.
    Good luck.
    Sam
    **** Video Details ****
    2:27 - using calculated columns
    6:13 - using a measure
    **** Learning Power BI? ****
    FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
    FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
    FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
    FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
    Enterprise DNA Online - www.enterprisedna.co/
    Enterprise DNA Membership - enterprisedna.co/membership
    Enterprise DNA Events - enterprisedna.co/enterprise-d...
    **** Related Links ****
    First Purchase Of Customer Insight Using DAX - blog.enterprisedna.co/discove...
    Last Purchase Date In Power BI: When Did Your Customers Make Their Last Purchase? - blog.enterprisedna.co/when-di...
    Working With Iterating Functions In DAX - blog.enterprisedna.co/working...
    **** Related Course Modules ****
    Time Intelligence Calculations - portal.enterprisedna.co/p/time...
    Unique Analytical Scenarios - portal.enterprisedna.co/p/uniq...
    Mastering DAX Calculations - portal.enterprisedna.co/p/mast...
    **** Related Support Forum Posts ****
    Calculate The Most Recent Value With DAX In Power BI - forum.enterprisedna.co/t/calc...
    Return Value Based On Most Recent Date - forum.enterprisedna.co/t/retu...
    Date Of Last Sale With Calculated Sale Price - forum.enterprisedna.co/t/date...
    For more calculate recent value support queries to review see here…. - forum.enterprisedna.co/search...

Комментарии • 87

  • @EnterpriseDNA
    @EnterpriseDNA  4 года назад +3

    ***** Learning Power BI? *****
    FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
    FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
    FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
    FREE - Power BI Resources - enterprisedna.co/power-bi-resources
    Enterprise DNA Online - www.enterprisedna.co/
    Enterprise DNA Membership - enterprisedna.co/membership
    Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
    ***** Related Links *****
    First Purchase Of Customer Insight Using DAX - blog.enterprisedna.co/discover-what-was-the-initial-product-a-customer-purchased-using-dax/
    Last Purchase Date In Power BI: When Did Your Customers Make Their Last Purchase? - blog.enterprisedna.co/when-did-your-customers-make-their-last-purchase-dax-techniques-in-power-bi/
    Working With Iterating Functions In DAX - blog.enterprisedna.co/working-with-iterating-functions-in-dax/
    ***** Related Course Modules *****
    Time Intelligence Calculations - portal.enterprisedna.co/p/time-intelligence-calculations
    Unique Analytical Scenarios - portal.enterprisedna.co/p/unique-analytical-scenarios
    Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
    ***** Related Support Forum Posts *****
    Calculate The Most Recent Value With DAX In Power BI - forum.enterprisedna.co/t/calculate-the-most-recent-value-with-dax-in-power-bi/2764
    Return Value Based On Most Recent Date - forum.enterprisedna.co/t/return-value-based-on-most-recent-date/5475
    Date Of Last Sale With Calculated Sale Price - forum.enterprisedna.co/t/date-of-last-sale-with-calculated-sale-price/2542
    For more calculate recent value support queries to review see here…. - forum.enterprisedna.co/search?q=calculate%20recent%20value

  • @87vaibhavtandon
    @87vaibhavtandon 5 лет назад +4

    Great video Sam! Would love to see more short videos like this explaining and resolving the real world bau issues.

  • @rdg515
    @rdg515 5 лет назад +9

    Thanks. Can you take this a concept a step further and demonstrate how to pull back a separate attribute from the most recent survey?

  • @MrDavisv
    @MrDavisv 4 года назад +1

    I really enjoy the videos! Can you do an example on how to reference the previous row in DAX (e.g., what is the difference in days between current row’s sales dates and the previous sales date?)

  • @justair07
    @justair07 4 года назад

    Awesome! Exactly what I was looking for. I actually needed to do this based on two columns. So I added another VAR for the other column and threw it in the filter. Works great!!

    • @munfordable
      @munfordable 3 года назад +2

      can you please show an example? I need to do the same thing

  • @eknol001
    @eknol001 4 года назад

    This is what i was looking for. Thanks.

  • @NdySerdu
    @NdySerdu 4 года назад

    Thank you for this amazing Vidéo ! Thank you so much for sharing. =) Keep up the good work !

  • @priyadarshinichettiar6750
    @priyadarshinichettiar6750 4 года назад

    Thanks a lot. This is awesome !!

  • @wiegunadjatmika6306
    @wiegunadjatmika6306 4 года назад +4

    Hi Sam,
    Could you share the trick how to get last value (text) on every single date or others dimension?

  • @fajnefajne4339
    @fajnefajne4339 3 года назад

    Thank you. Very useful.

  • @vishakhakumar3854
    @vishakhakumar3854 3 года назад

    Really glad to find this after a lot of scouring the internet.
    Thank you!

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hi Vishakha Kumar, 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

  • @safifaruqi
    @safifaruqi 3 года назад

    Thank you so much this helped me big time! if i wanted to add multiple filters to this current measure how would you go about approaching it.

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello Safi Faruqi,
      thank you for posting your query onto our channel.
      Well it's quite easy. Once the parenthesis of the first FILTER function is over than you can add the another FILTER function by putting the comma (,)symbol in between the two filters.
      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.
      Hoping you find this useful and meets your requirements that you've been looking for.
      Happy Learning!!!
      forum.enterprisedna.co/

  • @fernandofuzinattoportes3169
    @fernandofuzinattoportes3169 2 года назад

    You save me!!!!! thks!! This is fantastic resolution!! I needed to capture the last tag from the last session!

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hi Fernando, glad our content is of help. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

  • @sorinbuzuriu2652
    @sorinbuzuriu2652 4 года назад

    Thanks, Sam!
    I've used this logic to create a similar measure for the latest date (with data available) for every month.
    Cheers!

  • @lucasprado4250
    @lucasprado4250 3 года назад

    absolute life saver thanks a lot man

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hi Lucas Prado, 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

  • @Praaxx
    @Praaxx 5 лет назад +2

    Hello Sam,
    Thank you for all the videos, they are very informative. A couple of question on this one.
    I noticed when you add additional lines to your DAX formula window it plays the chime. If you use SHIFT+ENTER instead of ALT+ENTER it won't play the chime, at least it doesn't for me and I was happy to find that trick because the chime can be annoying.
    On the measures you use to calc the MAX date, wouldn't it be better (smaller memory usage) to use just the two needed columns in the filter statement rather than filtering the entire table?
    Max Date Measure =
    VAR CurrentUser = SELECTEDVALUE ( Table1[Name] )
    RETURN
    MAXX (
    FILTER ( ALL ( Table1[Name], Table1[Date Taken] ), Table1[Name] = CurrentUser ),
    Table1[Date Taken]
    )

    • @EnterpriseDNA
      @EnterpriseDNA  5 лет назад

      Appreciate the tip. Regarding the optimizing, yes there could be small differences, but in my view, these differences are so small I generally just keep it simple.

  • @LucianoVazBH
    @LucianoVazBH 2 года назад +1

    Excellent video, I've been looking for a content like this for a long time. how would you count the rows after this filter? I need to count how many rows that meet these criteria. need help.
    And count accumulating to max calendar date.

    • @EnterpriseDNA
      @EnterpriseDNA  Год назад

      Hi Luciano,
      Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
      Well, you can simply use the "COUNTROWS()" function in order to count the rows and use the concept of cumulative totals. We've created several video over the topic - "Cumulative Totals". Below are some of the links provided for the reference.
      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! You can subscribe to our RUclips channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI.
      Cheers,
      Enterprise DNA
      forum.enterprisedna.co/
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      www.linkedin.com/groups/12004506/
      blog.enterprisedna.co/how-to-use-the-countrows-dax-function-in-virtual-tables/
      ruclips.net/video/9tEoC6eAlJo/видео.html
      ruclips.net/video/JnhXyQ8eyuo/видео.html
      ruclips.net/video/3TLlxoTkBn0/видео.html

  • @branzo79
    @branzo79 3 года назад

    This is great. Now I need to find the previous from the max in the same month.

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hi Brandon McInnis, glad you appreciated the video. We are so grateful to have had such positive feedback.

  • @jontybuk
    @jontybuk 3 года назад

    Could this be used to select the role/post of an employee from a historical table of employee roles which has a start date and end date for each role the employee has been in? Any links to other videos would be greatly appreciated

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello jon bell,
      thank You for posting your query onto our channel.
      Well yes this type of concept can also be used very much in your case as well. But as of now it would a little bit difficult for us to comment and provide the results without looking at your data and the scenario that you're trying to achieve.
      You can write your query 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 our forum provided for the reference.
      Hoping you find this useful.
      Happy Learning!!!
      forum.enterprisedna.co/

  • @sonamverma2751
    @sonamverma2751 3 года назад +1

    Hi Sam, I have been watching your power bi videos for a while. They are a great help for my learning.
    If you could please let me know how would we get the last entry for each Name for each month, that would be a great help.

  • @jarrahalrowayyeh8990
    @jarrahalrowayyeh8990 4 года назад

    Thanks for the very informative video. i just have one Q, what if then i want the sum of the latest value ? could you please answer this question

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello Jarrah Alrowayyeh,
      Thank You for posting your query onto our channel.
      Well could you please post your query onto our community forum where our members as well as our Experts will be able to assist you in a better manner?
      We're providing a link below of our forum.
      Thanks and Warm Regards,
      Enterprise DNA
      forum.enterprisedna.co/

  • @Ocelot911
    @Ocelot911 3 года назад

    can we use lastdate instead?

  • @3danim8r1
    @3danim8r1 3 года назад

    Nice Solution!

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hi Nitin Verma, 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

  • @kanwalsingh2802
    @kanwalsingh2802 2 года назад

    Hi Sam, awesome teaching. Would you be able to help me if I do not want max value in all row when you are creating calculated column. Just want to show the result on the row which is last / Max.
    or, measure to count the last / Max value please.
    Thanks

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад +1

      Hello Kanwal Singh,
      Thank you for question. We appreciate your time.
      Based on the requirement that you've suggested, below are the DAX formula's provided for the reference -
      1). Max Date - Calculated Column -
      Max Date =
      VAR _Current_Name =
      'Survey Data'[Name]
      VAR _Results =
      MAXX(
      FILTER( ALL( 'Survey Data' ) ,
      'Survey Data'[Name] = _Current_Name ) ,
      'Survey Data'[Date Taken] )
      RETURN
      IF( 'Survey Data'[Date Taken] = _Results ,
      _Results ,
      BLANK() )
      2). Max Date - Measure -
      Max Date =
      VAR _Current_Name =
      SELECTEDVALUE( 'Survey Data'[Name] )
      VAR _Results =
      MAXX(
      FILTER( ALL( 'Survey Data' ) ,
      'Survey Data'[Name] = _Current_Name ) ,
      'Survey Data'[Date Taken] )
      RETURN
      IF( SELECTEDVALUE( 'Survey Data'[Date Taken] ) = _Results ,
      _Results ,
      BLANK() )
      For more queries, you can also reach out to us through our Community Forum where our members as well as Experts Team will be able to assist you, in a better and efficient manner.
      I hope this helps.
      Please make sure that you're subscribed to our RUclips channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference.
      Happy Learning!!!
      Thanks and Warm Regards,
      Enterprise DNA
      forum.enterprisedna.co/
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      www.linkedin.com/groups/12004506/

  • @abdulazad444
    @abdulazad444 3 года назад

    It is of very great help, calculated column calculation is working as expected, whereas the same DAX not working for measure, where DAX measure is giving wrong output. I am using switch statement to hide and show measures in matrix. Can you please help me in resolving the DAX measure calculation to get the expected output.

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello Abdul Azad,
      thank you for posting your query onto our channel.
      Well it's always a little bit difficult to judge and provide the results without looking at the data structure, working of the PBIX file also the results that you're trying to achieve by writing the SWITCH( TRUE() ) logic.
      And therefore 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 and the mock of the results that you're trying to achieve 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/

  • @ishwarsaini5144
    @ishwarsaini5144 Год назад +1

    Thank you

    • @EnterpriseDNA
      @EnterpriseDNA  Год назад

      Hi Ishwar, 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!

  • @nikakalichava8012
    @nikakalichava8012 6 месяцев назад

    this one actually hooked me up. tried to do similar with summarize,addcollums but did not work, then I came up with ieasier solution:
    CALCULATE(
    MAX('Table'[Date] ),
    ALLEXCEPT( 'Table' , 'Table'[Emp] )
    )

  • @ravimishra2994
    @ravimishra2994 4 года назад

    hi What if i want last date to be filtered based on another column value, for example in your sample, if i want "last date" against column "name" but it should be showing the date based on the filter of column "Q1" i.e if i put slicer and select Agree than it should show latest date when he agreed. Please help me with this

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hi Ravi,
      Yes, we can achieve this but we need to create Measure instead of Calculated Column.
      You may check the Enteprise DNA Forum for discussions about this topic.
      forum.enterprisedna.co/

  • @bartekbesz9943
    @bartekbesz9943 4 года назад

    You set "CurrentName" as 'SurveyDate'[Name] but how the second one is defined?

  • @ebrahimshafiei6201
    @ebrahimshafiei6201 2 года назад

    thanks a lot, I just had a question, when I add slicers in my visualization, this only returned the max for original table(not adjusted table based on slicers), I even used allselected instead of all but it didn't help, I would be grateful if you can say how can I fix this

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hello ebrahim shafiei,
      Thank you for question. We appreciate your time.
      It is a little difficult to tell and provide the results without looking at the data structure, model and working of the PBIX file. So we encourage you to please write back to us to our Community Forum by providing a thorough description of the problem that you're having along with the PBIX file you are using as reference, as well as the mock-up results that you're trying to achieve. Our members and/or experts team will be able to assist you in a better and efficient manner.
      I have provided the link to our forum below:
      forum.enterprisedna.co/
      Also make sure that you're subscribed to our RUclips channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference.

      Happy Learning!!!

      Thanks and Warm Regards,
      Enterprise DNA
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      www.linkedin.com/groups/12004506/

  • @LP-wg1ge
    @LP-wg1ge 4 года назад

    Hello, how about if the value is "TEXT"? let say the required information is the latest response to Q1/Q2/Q3/Q4 where max date taken are different in each person..

    • @EnterpriseDNA
      @EnterpriseDNA  4 года назад +1

      Hi Leal PERMALINO,
      Returning Text is a little different. However, it is important that you are considering the context and what you are trying to achieve.
      One Method would be
      1. Create a column called MaxDate
      MaxDate = CALCULATE(MAX(yourtablename[yourDatecolumn]),FILTER(yourtablename[Name]=EARLIER(yourtablename[Name])))
      What this does is computes the MaxDate by Name and popluates in all records grouping by Name.
      2. Create a column called IsLatest
      IsLatest = If([Date]=[MaxDate],"Latest","Older")
      3. Now create a report with relevant columns from yourtablename and use IsLatest column as a Visual Level Filter filtered for "Latest".
      Be sure to check out the Enterprise DNA forum for any specific queries the link below is where a question similar was posted.
      forum.enterprisedna.co/t/calculate-the-most-recent-value-with-dax-in-power-bi/2764/2
      Regards
      Enterprise DNA

    • @AHMEDALDAFAAE1
      @AHMEDALDAFAAE1 3 года назад

      Use LASTNONBLANK wrapped in CALCULATE like this
      Measure = CALCULATE(LASTNONBLANK([TEXT], 1),
      CALCULATETABLE( LASTDATE(Fact[Date]),
      ALLEXCEPT('FACT', 'DATE')))
      It may need a bit tweaking and it will work

  • @aliozturkmen
    @aliozturkmen 4 года назад

    Trying to do that with M - in edit queries. Any idea?

    • @EnterpriseDNA
      @EnterpriseDNA  4 года назад

      Hi Ali - You can get same result in M query by doing something like below.
      let
      Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjLWNTDSNTIwNFPSUfLKz8hTCM7NLMkAclwyixPTi1JTkZmxOkAdRrh0OEKVOyLUAk23RKjNSy3WUfBLzEuuxK7aFLdqv1SgHalFCjCnKOQXKWAxwQjJBMe8lNSi4vw8HQXXnMTMvFQCpuCWw/AJFpNxhpYZfn1ofogFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Date Taken" = _t, Name = _t, Q1 = _t, Q2 = _t]),
      #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date Taken", type date}, {"Name", type text}, {"Q1", type text}, {"Q2", type text}}),
      #"Grouped Rows" = Table.Group(#"Changed Type", {"Name"}, {{"AllRows", each _, type table [Date Taken=date, Name=text, Q1=text, Q2=text]}}),
      AddMaxDate = Table.AddColumn(#"Grouped Rows","MaxDate",each List.Max([AllRows][Date Taken])),
      #"Expanded AllRows" = Table.ExpandTableColumn(AddMaxDate, "AllRows", {"Date Taken", "Q1", "Q2"}, {"Date Taken", "Q1", "Q2"})
      in
      #"Expanded AllRows"
      For any specific query,raise request at DNA forum forum.enterprisedna.co/

  • @Kevin-kw8gu
    @Kevin-kw8gu 2 года назад

    I was using a calculated column for something similar and it kept crashing coz of memory. Switched to a measure and it works with barely any RAM, thanks.

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hi Kevin, great that this video is of help You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

  • @joygurubhatt
    @joygurubhatt 2 года назад

    Can I get the response on questions against the max date

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hi Sandipan, what was your question about the max date?

  • @singhzcity2219
    @singhzcity2219 2 года назад

    How to perform this function in case of two table. The first one which has the name and the. Second table which has dates?

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hello Singhz City,
      Thank you for posting your query onto our channel.
      Well, firstly your query itself is not clear to us here i.e. the scenario that you're trying to highlight and the results that you're trying to achieve with the provided scenario. And it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference.
      And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve 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. Make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI.
      Cheers,
      Enterprise DNA
      forum.enterprisedna.co/
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      www.linkedin.com/groups/12004506/

  • @giri41
    @giri41 3 года назад

    Sam .. please help me.. I want to show avg time over a week.. I cannt show aveg time in y axis

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello Lakshmi Giri,
      thank you for posting your query onto our channel.
      Well in Power BI there is no development so far in this phase. In Power BI, still we cannot show the Time on Y-axis. We're providing a link below from the Power BI forum where still it says there's no development and you can vote the idea by going through the link available in it.
      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 helpful.
      Happy Learning!!!
      community.powerbi.com/t5/Desktop/Display-time-on-y-axis-and-date-on-x-axis/m-p/926302
      forum.enterprisedna.co/

  • @dafran500
    @dafran500 3 года назад

    This works with direct query?

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello dafran500,
      thank you for posting your query onto our channel.
      Yes, the technique showcased using the "Measures" will also work in the "DirectQuery Mode" but the technique showcased using the "Calculated Column" will not work because the SELECTEDVALUE and FILTER function doesn't work in the DirectQuery mode in the form of Calculated Column. Below is the link of the article from the Microsoft provided for the reference -
      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.
      Also make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI.
      Happy Learning!!!
      forum.enterprisedna.co/
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      docs.microsoft.com/en-us/dax/filter-function-dax
      docs.microsoft.com/en-us/dax/selectedvalue-function

  • @endywuid
    @endywuid 2 года назад

    Please tell me how can I do this in Power Query, tx

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hello Endy,
      Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post.
      We'll try and create a video on this based on the requirement that you've suggested. But if you're requirement is based on an urgency than you can also raise your query onto our Enterprise DNA Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner.
      Hoping you find this useful. Also, make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
      Cheers,
      Enterprise DNA
      forum.enterprisedna.co/
      ruclips.net/user/EnterpriseDNA
      www.linkedin.com/groups/12004506/

  • @kathygilman3348
    @kathygilman3348 3 года назад

    Can anyone help with how to make this work if my date and ID (name) are in 2 different tables?

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello Kathy Gilman, thank you for posting your query onto our channel.
      Well we're not sure what's ID (Name) in your case and it's always a little bit difficult to judge and provide the results efficiently without looking at the data structure and PBIX file.
      We encourage you to please write back 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.
      Hoping you find this useful.
      Happy Learning!!!
      forum.enterprisedna.co/

  • @sophyrath9299
    @sophyrath9299 2 года назад

    That is interesting. if we want to count in Q1 how many people Agree and Disagree and count only the last transaction.

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад

      Hi Sophy, 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!

    • @sophyrath9299
      @sophyrath9299 2 года назад

      @@EnterpriseDNA I subscribed since i first learn PowerBI.

  • @vijaykumarbajjuri8220
    @vijaykumarbajjuri8220 Год назад

    need this as measure can any one help

    • @EnterpriseDNA
      @EnterpriseDNA  Год назад

      Hello Vijay Kumar Bajjuri,
      Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
      Well, if you go through the entire video then in the latter part, it showcases how to derive the results via measure.
      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! You can subscribe to our RUclips channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI.
      Cheers,
      Enterprise DNA
      forum.enterprisedna.co/
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      www.linkedin.com/groups/12004506/

  • @jwatkins320
    @jwatkins320 3 года назад

    how did he drag a copy like that? at 8:13

    • @EnterpriseDNA
      @EnterpriseDNA  3 года назад

      Hello J,
      thank you for posting your query onto our channel.
      Well it's just a normal copy and paste command. "Ctrl + C" for copy and "Ctrl + V" for paste.
      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.
      Hoping you find this useful and meets your requirements that you've been looking for.
      Happy Learning!!!
      forum.enterprisedna.co/

    • @jwatkins320
      @jwatkins320 3 года назад

      @@EnterpriseDNA some software packages have an option to do an alt + drag to duplicate features. I thought maybe I missed this option. Thanks for the reply!

  • @NadsRocker
    @NadsRocker 4 года назад

    Good idea but the logic seems flawed. What if we have 2 data rows on the same date ?

  • @sahiljainnit
    @sahiljainnit 4 года назад

    ENCOUNTERED THIS error...The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

    • @EnterpriseDNA
      @EnterpriseDNA  4 года назад

      Hi Sahil,
      Without looking at your model this is a difficult one to help you with.
      Some key points to note:
      • Make sure you have set up your data model correctly.
      • Make sure that all your columns are formatted to the correct data type.
      • Ensure that you are creating a measure as remember the formula for a column is slightly different.
      Be sure to checkout the original post in the enterprise forum where you can see both formulas.
      forum.enterprisedna.co/t/calculate-the-most-recent-value-with-dax-in-power-bi/2764/2
      Regards,
      Enterprise DNA

  • @sarveshdeshpande1772
    @sarveshdeshpande1772 2 года назад

    Easier way is -
    calculate(
    max(date Taken),
    Allexcept(Name)
    )

    • @EnterpriseDNA
      @EnterpriseDNA  2 года назад +1

      Hello sarvesh deshpande,
      Thank You for posting your alternative solution onto our channel. We really appreciate you taking your valuable time to post it.
      Well, yes this also works. In your solution, you've made a direct usage of "ALLEXCEPT()" function whereas in our scenario we used the "ALL()" function which removes all the contexts and then brought back the context over the Name by placing the condition as an expression under the "FILTER()" 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 helpful.🙂
      Also make sure that you're subscribed to our RUclips channel so that you don't miss out on any updates pertaining to the Power BI. Along with it, you can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
      Happy Learning!!!
      Thanks and Warm Regards,
      Enterprise DNA
      forum.enterprisedna.co/
      ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
      www.linkedin.com/groups/12004506/

  • @HasanAYousef
    @HasanAYousef Год назад +1

    Thank you

    • @EnterpriseDNA
      @EnterpriseDNA  Год назад

      Hi Hasan, 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!