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 ...
Hi,
Ensure that to the slicer and matrix visual, you drag Year and Month from the Calendar Table. Write this measure
Total = sum(Data[Amount])
Hope this helps.