Forum Discussion

alisonpappas's avatar
alisonpappas
Icon for Helper III rankHelper III
6 years ago
Solved

relationships between calendar table and imported data

Hi,   I am trying to make a relationship betweenan excel file I imported and a calendar table I created in Power BI. I have a bunch of data I want to be able to analyze on a rolling period basis. W...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Try this calculated column formula

    =IF(Data[Quarter]="Q1",DATE(Data[Year],1,1),IF(Data[Quarter]="Q2",DATE(Data[Year],4,1),IF(Data[Quarter]="Q3",DATE(Data[Year],7,1),DATE(Data[Year],10,1))))

    Hope this helps.

alisonpappas's avatar
alisonpappas
Icon for Helper III rankHelper III
6 years ago

Hi Anonymous ,

The top photo is the calendar I made and the bottom is my data. I want to be able to connect them by "Period" the running monthes-month index were all created by dax formula equations. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi alisonpappas 

 

Can you show me your bridge table as well?

  • alisonpappas's avatar
    alisonpappas
    Icon for Helper III rankHelper III
    6 years ago

    hi Anonymous

     

    this is the bridge i have as of right now 

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      Try this calculated column formula

      =IF(Data[Quarter]="Q1",DATE(Data[Year],1,1),IF(Data[Quarter]="Q2",DATE(Data[Year],4,1),IF(Data[Quarter]="Q3",DATE(Data[Year],7,1),DATE(Data[Year],10,1))))

      Hope this helps.