Forum Discussion

WimVan's avatar
WimVan
Icon for Helper I rankHelper I
7 years ago
Solved

Relationship problem between date columns from 2 tables

I have 2 tables: - 1 table "SubprojectsAll", loaded from sql via directquery, contains a date column named "Date last primary proposal revision"  (formatted in Power BI as date)   - 1 ...
Need Help
  • tex628's avatar
    tex628
    7 years ago

    And furthermore, it has to be done in the query editor. Does not work if you attempt to do it from the normal modelling pane!

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

WimVan 
Swap the 'date hierarchy' to date:

And if you want to upload a file, you need to do it through another service. Cant be done through the community website.

Br,
J

WimVan's avatar
WimVan
Icon for Helper I rankHelper I
7 years ago

I think the 1900 dates were coming from the fact that one of my tables had a column with dates of that year. 

After I removed those dates the calendarauto generated dates from 2000 onwards.

 

Anyway, I tried your suggestion with 

CALENDAR(DATE(2010,1,1),TODAY())

and also swapped hierarchy to "date".

 

Columns in both tables have data type  "Date" and format "yyyy-MM-dd"

 

Still I get an empty view (see the one to the right)

 

 

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi WimVan ,

    You can share the pbix file via Onedrive, then we can get more detailed information about this problem.

    Best Regards,

    Teige

    • WimVan's avatar
      WimVan
      Icon for Helper I rankHelper I
      7 years ago

      I have onedrive for business (from employer). I can share links to onevirtualoffice users but the url of the link contains my name...

       

      • TeigeGao's avatar
        TeigeGao
        Icon for Solution Sage rankSolution Sage
        7 years ago

        Maybe you can apply a Google Drive or a personal Onedrive 

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    This is seriusly messing with my head..... 

     

    Create a new page
    Remove any report level filters
    Add a table

    Add only the date column and the other column it has a relationship with.
    Post results

    Otherwise, if you can share the file, it would be the easiest way :p

    • WimVan's avatar
      WimVan
      Icon for Helper I rankHelper I
      7 years ago

      Will have to find a file sharing solution.

       

      Meanwhile tex628 I did what you asked:

      no report level filters

      just showing you the visual filters 

      • WimVan's avatar
        WimVan
        Icon for Helper I rankHelper I
        7 years ago

        And here also the relationship: