Forum Discussion

Sorakell's avatar
Sorakell
Frequent Visitor
7 years ago
Solved

Problem creating a dates column

Hello everybody.   I'm new using Power Bi and I need help doing a simple task that is causing me problems.   I'll try to explain as best as I can. I have a big table with lots of columns but in t...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    7 years ago

    Try this:

     

    New Column = CALCULATE(MAX(Table1[ColumnB]), ALLEXCEPT(Table1,Table1[ColumnA]))

    (LASTDATE instead of MAX should work just as well.)

     

    The ALLEXCPET removes all filter context except for the column(s) specified. Since we want to find the max over matching values in ColumnA, that's the filter context we want to keep.

AlexisOlson's avatar
AlexisOlson
Super User
7 years ago

Try this:

 

New Column = CALCULATE(MAX(Table1[ColumnB]), ALLEXCEPT(Table1,Table1[ColumnA]))

(LASTDATE instead of MAX should work just as well.)

 

The ALLEXCPET removes all filter context except for the column(s) specified. Since we want to find the max over matching values in ColumnA, that's the filter context we want to keep.

Sorakell's avatar
Sorakell
Frequent Visitor
7 years ago

Nice! IT WORKS!!!

 

I tried something similar before and failed but your formula worked perfectly! 

 

Thanks a lot Alexis. I have done some nice things with power bi, but i'm new in this world and sometimes a simple task (or not so simple) requires me lots of time to resolve.

 

Thanks! very appreciated!

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    7 years ago

    Please mark it as a solution if it solved your problem and award kudos (thumbs up) if you feel like it.