TabularEditorScripts icon indicating copy to clipboard operation
TabularEditorScripts copied to clipboard

Create hide future date lodgic based on detail expression saved in admin table

Open samaguire opened this issue 2 years ago • 0 comments

https://www.sqlbi.com/articles/creating-table-functions-in-dax-using-detailrows/

The idea is to use the table to create a list of measures that are the exceptions to hidding future dates, then pull the detailed query so that a specific date can be used, i.e. sales never go passed today, else budget & forcast may go upuntil the end of data.

it might just be easier to have 3 measure that are hidden against the TI table: AC, PL, FC

samaguire avatar Apr 20 '22 13:04 samaguire