Forum Discussion

jnn4282's avatar
jnn4282
Helper II
4 years ago

Calendar issue

https://app.powerbi.com/links/iIz-nEedoY?ctid=f75c0628-6e7b-41e9-86a8-0f32146077da&pbi_source=linkShare   Hi friends, I want your help. My data table only has FY and month columns, as you can see ...
Need Help
  • jnn4282's avatar
    jnn4282
    Helper II
    4 years ago

    Thank you amitchandak 

    I will check the link you provided. Then, if I get stocked somewhere, I will approach again.

  • jnn4282's avatar
    jnn4282
    Helper II
    4 years ago

    Thank you for the calendar and works perfectly.

    But how do I connect to my PL table( relationship)? Since my PL table does not have any Date data type.

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      4 years ago

      Hi jnn4282 

       

      Can you please show some dummy data of your PL table? If it doesn't have any date data type columns, you can add columns like "Month Start Date", "Month End Date" based on existing columns like Month, Year or any date related columns you have in PL table. Then build a relationship between "Month Start Date" (or "Month End Date") and the Date column in Calendar table. 

       

      Best Regards,
      Community Support Team _ Jing
      If this post helps, please Accept it as Solution to help other members find it.