Selected Tags:

dax, faq
Available Tags: excel
Title Author Date
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? Vidas Matelis 11/29/2009
Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months) Vidas Matelis 12/05/2009
How to add DAX calculations to the PowerPivot workbooks Vidas Matelis 12/18/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? Vidas Matelis 03/10/2010
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? Vidas Matelis 03/17/2010