Excel 2013 Power BI Tools Part 13 - Date Functions within PowerPivot / DAX

By Andy Brown

If you've created a calendar table in your PowerPivot data model, this tutorial shows how you can use a variety of useful-sounding DAX functions like SAMEPERIODLASTYEAR, TOTALYTD and PARALLELPERIOD to analyse time-based data in pivot tables.

[CNDVideoProductions]

Great Video!! Always love some PowerQuery/PowerPivot videos!

Within your ratio calculation at 11:47 it would be practice to use the DIVIDE function to error trap the divide by zero error. 

DIVIDE(Numerator, Denominator, [AlternateResult])

Where AlternateResult would equal BLANK() in your example.

[jazzista]

Andy: Thanks for posting and sharing your BI knowledge. Great videos specially your humor while explaining your DAX formulas.  I have a question for semi-additive functions: I am trying to write a formula so it shows the cumulative balance of GL accounts for month ending in Sep, Oct, Nov & Dec. I am trying to use the YTD function but I am still getting the monthly activity. Any suggestions?. Thanks in advance

[frankpeeters]

Hi, excellent video. Thanks
I am trying to create a formular showing the ytd sales till today next to the ytd sales of last year till this date. How can you create the previous year information?

[sureshaitha]

I want to create a formula for previous week, parallel period is only for month, quarter, year. How to calculate for previous week ?

[jbricardo]

Hi friends. I need to know how do I do to Subtract 2 dates to get the days elapsed between those 2 dates

[sureshsql]

Previous week calculation is until end of previous fiscal week, there is no start date. Total amount is until end of previous fiscal week. How to create the formula for previous week until end of previous fiscal week ?

[АлександрДергилёв-пх]

I'm so happy :) make more movie :)