DAX Fridays #215: Previous row in DAX non-accumulated values

I showed you on a previous video how to get previous row using dax on an accumulated column:

In today's video we will do it for non-accumulated values!

If you need a refresher on DATEADD function, here it the explainer video:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10

Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[shivasai]

where i can practice, more scenarios in dax for every function
@curbal

[pilarbaldominos]

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!

[SergioGonzalez-puwh]

Just implemented this one. It worked perfectly! Thanks

[roywilson]

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!

[visheshjjain]

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?

[elvinlee]

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

[MrRagerrrr]

what if your dealing with financial year? how do you do the date add? thanks! please help

[ManiV]

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

[udusegbe]

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?

[jishnusachidanandan]

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.

[koteswaribapatla]

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.

[vyasrahul]

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.

[TheKermit]

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]

Muchas Gracias Ruth!!, Excelente video

[yagodde]

And if my dates are not the same? how would i solve that in DAX?

[venkatareddykummitha]

Do a videos on SELECTED VISUALS IN Bookmarks please.. I am really confused while doing this work on whenever

[tanayrajjhagadiawala]

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.