Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DATES Table - relationship not working completely

Hi guys, I am new to BI and playing with some data. I have historical data with order history for last year (order ref, datecreated (as datetime), amount - which is loaded via a query.  As I need mo...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

 

What relationship did you create between the FullCalendar and  Historical FYTD table?

 THen I created 2 tables on the canvas, one based on the historical data query (order count) with the "Month-Year name" column from the query and another one with the order count from the query and with "Month-Year name" column from the Data table. 

The count # is the same however the Month-Year no# do not match for some months. The table created with the "Month-Year name" from the data table I created returns 19 orders with blank for Month-Year. 

Not sure why this happens, can you help? 

 

By my test based on your description, I cannot reproduce your issue. Could you share some screenshots to describe your scenario better?

 

If it is convenient, please share the sample table structure and your desired output so that we could help further on it.

 

Best  Regards,

Cherry