MEASURES vs CALCULATED COLUMNS in DAX

[@ebenholz86]

Thanks! I love that you provided links to the data

[@NestorAdrianzen]

Glad it was helpful! Keep up the great work, Lesley!

[@bibekanandabhattacharjee952]

Good one but I think I need to practice more and more to understand it thoroughly. Thank you @Nestor Adrianzen .

[@NestorAdrianzen]

Welcome to the DAX world, Bibekananda!

[@joelkaragacha1288]

Genius step by step!

[@NestorAdrianzen]

Joel, Glad you found the content helpful. Keep it up!👍

[@kanumarlapudikrishnakanth8119]

Beautiful Explanation

[@NestorAdrianzen]

Glad you found it helpful. 👍

[@eduardomunoz2764]

Excelente como siempre!.. Saludos Néstor

[@NestorAdrianzen]

Glad it helped, Eduardo!

[@danjarupath]

Love your vdo Make it more my man

[@NestorAdrianzen]

Glad you found it helpful. Keep it up!

[@thanomnoimoh9299]

Great pbi clip !! Go on

[@NestorAdrianzen]

Thanom, thanks for stopping by. Glad this was helpful.

[@hermerbalan82]

Thanks a Lot !

[@NestorAdrianzen]

Glad it helped!

[@raghun2636]

what is current row???everyone keeps saying this but did not see a proper explaination

[@NestorAdrianzen]

Raghu N, Did you mean Row Context? If so, it's one of the contexts in DAX. Every time we create calculated columns and use iterating functions in DAX like SUMX, there is row context.

[@danjarupath]

Cool

[@NestorAdrianzen]

Excellent!

[@jrazafindrabe5229]

BOOM !!!

[@NestorAdrianzen]

Keep up the good work, J Raz!

[@sravankumar1767]

I have one doubt can you explain week measures like, Total Amount week to date, Total Amount for last week, Total Amount for same week last year, Period Measures Like Total amount Period to date &&& How to create Date [twomonthperiod] column date table can you please explain briefly...

[@NestorAdrianzen]

Sravan Kumar, For time intelligence calculations, you might want to use the DATEADD function: e.g., DATEADD (Dates[Date], -7, DAY). If you haven't done so, you might want check the following tutorial out for more details: kzbin.info/www/bejne/aWPadZ2qhaerh7s

[@mohdmuzammil3059]

1st like 👍

[@NestorAdrianzen]

That's great! Thanks!