Forum Discussion
Using a measure to define a CALCULATETABLE
- 2 years ago
Hey SebaSpotti ,
you can try the following:
CalcTable = VAR _ExamMonth = [ExamMonth] RETURN CALCULATETABLE ( Table, Table[Name] IN { "A", "C", "F" }, MONTH ( Table[Date] ) = _ExamMonth )I'm wondering, what exactly do you plan to do?
Do you want to use that in a measure or do you want to use that as a calculated table? Be aware if you are using a calculated table, that table is not dynamic. So after loading the file, the table won't change anymore.If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Hey SebaSpotti ,
you can try the following:
CalcTable =
VAR _ExamMonth = [ExamMonth]
RETURN
CALCULATETABLE (
Table,
Table[Name] IN { "A", "C", "F" },
MONTH ( Table[Date] ) = _ExamMonth
)
I'm wondering, what exactly do you plan to do?
Do you want to use that in a measure or do you want to use that as a calculated table? Be aware if you are using a calculated table, that table is not dynamic. So after loading the file, the table won't change anymore.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
selimovd thank you!
I was simply trying to calculate some measure, but probably i need them to be update so i'm changing the calculations.