dax

Display # 5 10 15 20 25 30 50 100 All

PowerPivot's Filter Context from a SQL perspective

Written by Vincent Baldwin on 15 August 2012.

Prepayments and Deferred Revenue

Written by David Churchward on 24 January 2012.

Profiling data in PowerPivot: comparing two tables

Written by Javier Guillen on 05 November 2012.

Profiling data in PowerPivot: Detecting duplicates

Written by Javier Guillen on 15 October 2012.

Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel

Written by Microsoft on 15 May 2013.

Profit and Loss-The Art of the Cascading Subtotal

Written by David Churchward on 15 September 2011.

Protecting time intelligence expressions against non-consecutive range of days

Written by Dany Hoter on 08 April 2015.

Putting the "Intelligence" in "Business Intelligence"

Written by Rob Collie on 07 December 2009.

Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)

Written by Vidas Matelis on 05 December 2009.

Q: I have a field in the pivot that shows duration on some event in seconds. How can I create calculated measure using DAX that would convert numeric result (seconds) to string in the format hh:mm:ss?

Written by Vidas Matelis on 10 March 2010.

Q: I have integer amount that represents duration in seconds. How can show this amount in format "h:mm:ss"?

Written by Vidas Matelis on 26 October 2010.

Q: In my source data I have daily balance values. How in PowerPivot for Excel can I create calculation that shows correct closing balance for year, quarter and month?

Written by Vidas Matelis on 29 November 2009.

Q: My DAX formula in the PowePivot returns error message: "The value for columns "ColumnName1" in table "Table1" cannot be determined in the current context. How can I fix this?

Written by Vidas Matelis on 17 March 2010.

Quadruple Nested SUMX or CROSSJOIN

Written by Vidas Matelis on 21 March 2016.

Quantum shifts with PowerPivot

Written by Ken Puls on 07 October 2010.

Quartile, Percentile and Median in PowerPivot

Written by Javier Guillen on 12 July 2011.

Quick Tip: Don’t Over-Use FILTER()

Written by Rob Collie on 08 April 2010.

QuickStart: Learn DAX Basics in 30 Minutes

Written by Owen Duncan on 29 January 2012.

Ranking within Slicer Selection in Power Pivot

Written by Jason Thomas on 22 May 2014.

RANKX with Ascending Order to Show Lowest Quotes by Vendors

Written by Avi Singh on 16 July 2015.

• 19
• 20
• 21
• 22
• 23
• 24
• 25