Power BI DAX Tutorial (2/50) - What is Measure or Calculated Column

When to use Measure / Calculated Column in Power BI, How measure is calculated on runtime, What is Measure and calculated column in Power BI, How to create a Simple Measure in Power BI, How to create a Simple Calculated column in Power BI, Basics of DAX , Power BI DAX Tutorial with Examples

#powerbi #powerbidax #daxmeasure

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[SairamV]

its took deep 20 min to understand the previous year sales formula :) Thank god :):)

[irfandaud]

Thank You Nags, Excellent explanation ... looking forward to DAX Vidos from 40 - 50...Thank you for creating this great channel

[bhavanit]

Sir i have one doubt let us consider our table has 2 sales value for same catagory.

lets say watches if I put the category in table if I don't apply measure then what would be sales still it will sum up 2 values in table

or it will pick up value of first watches row

[FirozKhan-vitn]

where is dataset has used in your video. from where i download same dataset

[sandhyapenmetsa]

Hi Sir, I tried to create the measure using sameperiodlastyear. But the sameperiodlastyear forumla shows error in the measure. Please clarified my doubt.

[mhn]

Very well explained, Sir. However, would request you to provide datasets with us so that as beginners, we can practice with the same eg. that you've used for demonstration.

[babutechnicall]

Hello Nag,

i have tried to analyze last year data with current year data just like you shown.. here i tried to convert the sale date column as date data type and not used [sale date].[date]
i have used [sale date] directly in the sameperiodlastyear function.. it is not showing any data in the lastyear column of the table visual.. later i used [sale date].[date] as you shown then it worked..
why should we use this .[date] even the type of data is date?
kindly provide your inputs.

Thanks,
babu

[tejaswipalla]

Hi Sir, I tried to create the measure using sameperiodlastyear. when I created a tabular visual i couldn't see the previous year values to compare with current year. but i can see the sum correctly for both measures .what could be problem that previous year values are not visible.

[hemangrathore]

Hi when I drop sales date in the table, in the drop down it not showing me year, month, day

[debduttaroy]

Sir, sameperiodlastyear is not working for me .. It is Prev year sales = CALCULATE(sum([Sales Amount]), SAMEPERIODLASTYEAR(Data[Sale date])) coming in my power BI desktop . ".date" is not coming and showing error.

[VimalKumar-kzyg]

hi sir so which is best to use calculated colum are mesure

[WeekendGhumakkadd]

Unable to add new measure in xaxis in clustered bar chart, how can this be resolved..please reply

[harshalpatel]

Where can we get datasets used in the videos ?

[isNew]

Where is the link of the database file and final output? How can we download it?

[saikiran]

is it possible that sameperiodlastyear function to do in calculated column?

[ismailabid]

Hello
Sir the rest of videos from 39 to 50 have not uploaded
Will u upload?
Thanks

[debduttaroy]

Hi Sir, from where to download naga garment excel sheet?

[kavalisony]

Good explanation sir thank you so much❤

[kalyankothapalli]

That was very smooth explanation thank you bro.

[shahinashaik]

Hi Nag. Can I get the dataset for practice..Thanks in advance