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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Charu

    I have requested access and might be able to look in to it tonight.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Charu

    I will share my file here: https://1drv.ms/u/s!AgUIGKdICZfnj1p5k--kOjLDw9py

    Just change the source in Edit Queries to your file again if you want to add some more stuff.

    What I did is that i created another table with a column based on your date filter column. A formula like this:

    Dates = CALENDAR(FIRSTDATE(InvoiceDate[date filter]);LASTDATE(InvoiceDate[date filter]))

    Then i connect this to your customer table and add that column to your datesbetween slicer. This makes it work.

    Let me know that this is what you are looking for or if i missunderstand you. I think the problem has been that here only has been two dates here and that you need all the datesbetween somewhere for the slicer to work. If you only want the datefilter values then you have to have a list or something.

    Br,
    Gurrato