Forum Discussion
Date Measure
Mikelytics This is my current data model:
I just want to apologize in advance for not being able to share my pbix file and masking all of the table names/fields, as there is highly sensitive data in the file. The highlighted table is obviously my date table, and all tables circled in blue report metrics that will use the custom date filter that this post is about. These metrics are more just reporting all values for the time period, instead of performing a calculation of sorts. The red circled tables need to be based on the same date table, but they only show a snapshot of the data from whatever the month selected is, hence why I want to have the user select only a month. In the end I hope that I can have the user select the month they want to see and the red circled tables will show only that month's data, and the blue circled tables will show all data from the beginning of the year to the end of the month selected.
piuh , okay. But no worries I fully understand that you can not share the data, but at least a get a big picture. 🙂
I mean I know you want to show data but still you do a calculation right. For the red table you takr for example the sum or max of a column for a specific month. and for the blue tables you take the sum over several months. Something like this would be possible with the appraoch I described.
Can you build an easy example with dummy data? I mean it can be a few rows manually typed in Excel.
- 1 date table (this I know how it looks like) 😉
- 1 red table example
- 1 blue table example
- and an example what you want to Calculate/vizualize
It only has to be a few rows per table
Best regards
Michael
Mikelytics Ok I put together some test data as a proof of concept. This is a screenshot of what I want to get:
AS a note of reference, this table has two slicers that are only interacting with the visual that is in the same box, but in my actual project, I would like there to only be one slider like the one that selects a month name. As you can see, the "blue table" will show all metrics with dates between the beginning of the year and the end of the month name that is selected, while the "red table" will only show data for a singular selected month.
Unfortunately my organization does not allow for sharing of any files, as the file share is not an option for me to select.