Hi all,
I couldn't find a comprehensive answer to this question albeit googling quite a bit, so here goes:
I have a simple line chart built over the automatic date hierarchy, with the drilldown option enabled.
I would like to filter out from the chart the last incomplete date period, depending on the displayed hierarchy level.
For example, when viewing the chart on the daily level, I would like to display data only up to yesterday's date.
For weekly - up to last week. and so on.
I know how to do it in Tableau, but Power BI works differently and the pin hadn't completely dropped yet.
Ideally, I'd like to learn the answer to the following:
* What is the best practice to filter the last incomplete date? Using a calculated column? A measure?
* What modifications need to be made to allow it to work with a drill-down?
* Assuming both ways are viable (which might be wrong), what are the pros and cons of each way?
* In general, what do I need to take into account when creating a calculation with DAX that is supposed to behave in a certain way when changing levels?
I understand I'm asking for a lot here, I'd greatly appreciate an answer to just the first two bullets.
Thank you!
Amit
