Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

USERELATIONSHIP THROWING ERROR

Hello, Below code throws an error "USERELATIONSHIP function can only use the two columns references participating in relationship." Cases Last 13 Month = var MaxDate = MAX('Calendar'[Calendar_la...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you Mahesh0016 , BUT GETTING SAME ERROR.

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

Anonymous Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Mahesh0016 ,

    I wish I could share the pbix file after removing the sensitive data but the file is bit of large and removing things could take a lot of time.

    . however my goal is to user should be able to see past 13 months of data based on the month selected. for example. if some one selects "01/31/2023" , user should see past 13 months iof data like below

    Date                Volume
    01/31/2023       10
    12/31/2022       30
    .
    .
    .
    01/31/2022       35

    my input table is also in the same format as above but with one additional column added

    Date                  site    Volume
    01/31/2023        1         5

    01/31/2023         2        5
    12/31/2022        1        10

    12/31/2022        2        10

    12/31/2022        3        10
    .
    .
    .
    01/31/2022        3        35

     

    I am generating calendar like this

    Calendar = CALENDARAUTO()
     
    and presentation calendar = 'Calendar'.
     
    Please let me know if these info help. Thanks