Forum Discussion
FrankMcQ
6 years agoFrequent Visitor
Build a column based on a date filter from another table
Hi I have a table of milestones: Year Start Date End Date Q1 Q2 Q3 Q4 2018 01/10/2017 31/09/2018 ...
- 6 years ago
Perfect, Many thanks!
amitchandak
Super User
6 years agoThese calculations will for the column, not for the measure. For measure is expects a single value. This means you have to take a min or max of another table.
Not sure why you creating a table like this you can use a calendar in powerbi to do this is a much better manner.
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/