Forum Discussion

Charu's avatar
Charu
Post Patron
8 years ago

How to create Calculated column to get date values based on status in power bi

Hi Everyone,   please help me to create the calculated column to get the date values based on Status column values. For example, in the table, I'm having data like below and in power bi dat...
Need Help
Charu's avatar
Charu
Post Patron
8 years ago

Hi Anonymous

The Datasource is oracle table 

1.Periodtable

2.customertable(table name)-- has some fields in addition date column which will be having April, may so and so data but in date filter i need a column where it should take from-date from the period table and todate as system date. 

 

 

here in table visual for customer table, I have used the date filter from the period table, as it is in between Apr1st to Apr11 those records only should display in the table visual 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How does your relationship look like in Power BI and in Oracle. Seems like the relationship is not correct at the moment between date and customer. As to your calculated column it shouldnt be a problem to create one as you did in your first post here.

Can you see your relationships in Power BI at all at the moment?


  • Charu's avatar
    Charu
    Post Patron
    8 years ago

    HI Anonymous

    I have tried with all the possible Relationships between the period_Table and Customer Table.Nothing works out.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI Charu

      Can you share some data and upload a pbix so I can try it?

      Br,
      Gustav