Need help for a Visualization and Associated Data Modelling

[Anonymous]

Hi all,

I am currently working on a time series data with the following structure:

Timestamp - ID - EVENT-TYPE

EVENT-TYPE is a column used to track entries and exits and is mapped to a column with +1/-1 as values, with +1 for entry and -1 for exit. Timestamps are Hourly, Non-Unique and Irregular (There can be multiple entries and exits in an hour, and no timestamps for time periods with zero footfall, usually on weekends and during night time)

I am currently using a cumulative sum measure on this EVENT-TYPE column to visualize the total occupancy at any given time,and it's working fine.

But I also want to allow my users to select any subset of the ID's and shift their in/out times by a certain amount and then see what impact it has on the overall occupancy. I am at my wit's end on how to figure this out, especially as I am not that experienced with the whole DAX/M/PowerBI ecosystem and am really struggling on how to do this.

I would really appreciate if someone could show me how to do this in PowerBI.

Please also let me know If I have missed any crucial details, or If I am asking this in the wrong section.

[v-evelk]

Hi,

I am not sure that I took you correctly because DAX and data transformation is out of my expertise.

I can recommend the following solutions:

1. It is unclear what visuals you currently use. I recommend to check Power BI Visuals store that, as I know, contains couple of Time Series visuals

2. For advice regarding data transformation, using DAX, for instance, you should ask in this and this threads.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

[Anonymous]

I have also asked this in the DAX Commands section, with more clarifications, but haven't got a reply yet.

The link is at: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Need-help-for-a-visualization-and-associated-...