Forum Discussion
Incremental Refresh Power BI
- 4 years ago
No prob. Glad to help. If anything I have said helps, please "accept as solution" for that part so this thread can be known to be solved.
Put this in a blank query.
let
Source = {Number.From(#date(2021,1,1))..Number.From(#date(2021,12,31))},
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error),
#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Date", type datetime}})
in
#"Changed Type"
that will give you a list of dates in the datetime format from Jan 1 to Dec 31 of 2021.
But I honestly don't see what a list has to do with a measure. Lists are in Power Query and do not load to the data model. They get stripped off.
I think you are way beyond what is needed for incremental refresh.
I suggest you ask different questions for measures in the DAX forum and just focus on getting incremental refresh to work here.
If you are still having issues with Incremental Refresh, please ask a comprehensive question on your specific issue. All we have are bits and pieces. Remember, we don't have your PBIX file, nor understand your data, so partial questions only delay a good answer. We are about 10 posts deep here already and no solution.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Thank you for the suggestion. I will be doing that I truly appreciate your reply as I am new to this forum and tool.
- edhans4 years agoCommunity Champion
No prob. Glad to help. If anything I have said helps, please "accept as solution" for that part so this thread can be known to be solved.