Forum Discussion
Get information based on date range
Thank you it helps .
Is it normal?
yes, that is normal.
Also note the remarks section
Will I use the Related() function in this case? I also want to mention that my result column (based on the 7 selected days) is a measure Dax and I indicated that I cannot include a measure in another measure.
RELATED() is only something you need for calculated columns. Measures use the data model. If your tables are unrelated then you can try TREATAS() but that may have the same Direct Query limitations.
Please provide more details about your actual setup, the participating data sources, the data model etc. It is difficult to help if the overall scenario is not clear.
My actual setup is :
All of my tables use Direct Query mode. So to calculate something, I always have to do Measure. I'm not able to use a calculated column.
Let me explain your clarely what I have and what I want.
I have a table named DIM_Temps which is a date table and all other tables are values tables.
With that, I have a Folder with all measures of the project, and the one that interests me is named Ponctu_O.
This measure is already calcultate using the Dax expression DIVIDE so there is no problem at this point.
The fact is that in a visual table, I'm able to show [Ponctu_O] and filter the value with a segment visual which contains the date.
And now, I want to be able to show the value of this measure for the 7 days before the date selected in the date filter.
I'm not able to create a new column with the second date because I'm in Direct Query Mode.
Do you understand my situation better?