time intelligence

Hello, I have data on about 100 companies that is fed by a SharePoint list that has versions turned on. Over time, the SharePoint list is updated with new information. For example, as the number of employees changes, it gets updated. What I'd like to do is add a date slicer so a user can...

Hello Everyone, I have this dataset (click here) of items with time stamped stages. Some stages mean the item is occupying space in the storage. The other stages mean it's not. I need to use Power Pivot 2016 (not Power BI) to produce the chart below for avg. storage occupancy over time for the...

I'm putting a monthly sales report together that we'll send our sales people, and what my end goal is, is a pivot that list the Salespeople, their Accounts, and then their sales across different periods, something like this for February, and have the report created each month with a rolling...

If I have a simple measure Total Sales:=SUM(fact[Sales]) what would be best way to calculate percent change from a specified date? For example if I select 1/15/2014 from a slicer or filter, the measure would calculate percent change of Total Sales for the filter context versus 1/15/2014?

Hello All, I am struggling to develop a PowerPivot measure that can project global MTD and/or YTD figures based on sales in different areas of the world. I have no issues with the measure assuming the globe runs on the same calendar, but I am running into challenges having the calculation be...

Hi, I have data table in PowerPivot that includes list of thousands of different retail items, their product categories, the date they were purchased, selling store, and their sale prices. I've created pivot table to cut the data, and slice by store, product category, etc. with the value...

Hello there, Does anyone know if there's any way to adjust the <interval> argument of functions like DATEADD according to filter context? The argument takes enumerations, not text strings or numbers that would be easily swapped with some IF logic. At the moment, I'm doing things like this...

I'm working with PowerPivot and DAX and what I need is to write a Calculated Field that will return a single number that is the number of workdays left in the month. I have a date table included with an IsWorkday calculated column which returns a 1 for a workday (Monday-Friday) and a 0 for a...

What is the temporary workaround to use time intelligence functions for non-contiguous date ranges? For example, I'm having the same error that this user is having. For example, my new measure created is: =calculate(sum(TE_INTL[Entry Approved Amount]),dateadd(Calendar[Date],-1,month))...