Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Mapping for different column with same value

Dear all, I'm now working on power bi connecting a live database. In the database, there are two time buckets( which have common value), relete to two sets of data that I'd like to compare in one gr...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    There's no ways to add the calendar table under the live-connection mode unless you add it in the data source.

     

     

SpiroswayGR's avatar
SpiroswayGR
Resolver III
6 years ago

Anonymous 

If you create a calendar table and relate both "Tables" of your database then i think you can graph them easily.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

can you explain a bit more how to create a calendar and then relate to tables? my value in column is like "2018jun", do I need to convert it to date format or? cuz when I set a new measure

TestDate = CALENDAR(DATE(2019;1;1);DATE(2019;12;12)), there is a error message "a table of multiple values was supplied where a single value was expected".
Thanks in advance