Forum Discussion
Get latest values for N last days using DirectQuery
I have a table that has Date column and Value column. I am using SQL Server with DirectQuery mode. I need to build a chart that has latest values for each of 2 last days. Should look like here: ...
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi andriikubrak,
1. How to add dates like "Fri"?
1) If you can add a week column in the database, you can try to add a new column in the PBI.
Week = LEFT ( [Day of Week], 3 )
2) If you can't, I wound if you can accept the format like this: "Sunday 1 January 2017".
2. About Max. Does the second max date have some features? For example, it's the max date minus 1.
Because "Function 'FILTER' is not supported in this context in DirectQuery mode". We can't use filter to get the second max date. Or you have to do it in the database.
Best Regards!
Dale