Forum Discussion

dansimmons's avatar
dansimmons
Frequent Visitor
4 years ago

Pulling comments from 'Comments' table based on slicer selections

Hi,   I'm trying to add comments to my dashboard which will pull from a 'Comments' table that I have created. This table contains the following columns:   - Month - Territory - KPI - Value (i....
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

dansimmons , Using Month You should create a date

say you have month like Jan-2022

Date = datevalue("01-" &[Month])

or

Date = ("01-" &[Month]) // change data type to date

 

Or create date by using month

 

You need to have a common dimension to Territory and  KPI

 

example

Territory= distinct(Union(distinct(KPITable[Territory]), distinct(comments[Territory])) )

 

KPI= distinct(Union(distinct(KPITable[KPI]), distinct(comments[KPI])) )

 

 

Join these with both table and use common filters now