Forum Discussion
Months between dates
Hello, I have a calendar table [Table 1] with dates from 2015 to 2030 which has dates, month, month_year, year etc I have another table [Table 2] which has facts. This fact table has 2 measures ...
Ashish_Mathur where does this measure go,I mean which table? If i use this measure to filter out the visual and slicer by using is not blank, i will not get the apr and may 16. Am i missing something here?
Just for context, my Calendar table is filtering Facts table with 1 to * cardinality
Measures do not belong to any table. They can be stored anywhere. Also, this measure simply has to be dragged to your matrix/table visual.