Forum Discussion
BenCollins
3 years agoNew Member
Time Intelligence in Tabular Editor
I've created a time calculation period of QTD and Quarter in Tabular Editor. I've created Quarter as VAR SelectedQuarterStart = CALCULATE(MAX(DocumentDate[QuarterStart]), ALLSELECTED(DocumentDate...
- 3 years ago
I've actually solved my own problem. Sorry for the inconvenience everyone, but if it's bugging anyone what it was it was because I had missed a _DaysSelected from my ADDCOLUMNS section
ADDCOLUMNS ( CALCULATETABLE ( DATEADD ( DocumentDate[Date], -3, MONTH ),_DaysSelected ), "Range", "Qtrs" ),
BenCollins
3 years agoNew Member
I've actually solved my own problem. Sorry for the inconvenience everyone, but if it's bugging anyone what it was it was because I had missed a _DaysSelected from my ADDCOLUMNS section
ADDCOLUMNS ( CALCULATETABLE ( DATEADD ( DocumentDate[Date], -3, MONTH ),_DaysSelected ), "Range", "Qtrs" ),
- MFelix3 years agoSuper User
Hi BenCollins ,
These are the best kind of issues were the users solve it's own problem. 😂 (just kidding).
Don't forget to accept your answer as solution so it can help others.