cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Applying a Common Slicer to two tables without connecting them

Hi, 

 

  • I have two tables (Date and Exec_CivilMonthStats) and a common date column (ReportMonthEnd) in both of them. 

 

  • I want to have ReportMonthEnd column in the Date table to used as a common slicer which I am not able to do or MMMM-YYYY to drive my tables.  

 

  • To give a more context why I am doing this as in Exec_CivilMonthStats table I have a calculated field for "Last twelvemonths data" with below formula

 

Finalized LTM =
VAR CurrentDate = MAX('Date'[ReportMonthEnd])
Var PreviousDate = DATE(YEAR(CurrentDate)-1,MONTH(CurrentDate), DAY(CurrentDate))
Var Result =
CALCULATE(
SUM(Exec_CivilMonthStats[Finalized Flag]),
FILTER(
Exec_CivilMonthStats, Exec_CivilMonthStats[ReportMonthEnd] >=PreviousDate && Exec_CivilMonthStats[ReportMonthEnd]<=CurrentDate
)
)
Return
Result
 
If I use ReportMonthEnd from Exec_CivilMonthStats table, then it narrows down my result to that particular month for "Finalized LTM" instead of showing last twelve months for "Finalized LTM".
 
Please refer to Page 1 and Page 2 of the attached workbook where Page 2 shows the unwanted change to Finalized LTM. 
 

https://drive.google.com/open?id=1QmPgG6CJEQzxE9vYtjqR_s1eeVdAMbd-

2 REPLIES 2
Community Support
Community Support

Hi @SauravSidana ,

 

I cannot access the file you shared, Could you please share it again?

 

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors