DAX Help- Logical

Anonymous — Tue, 20 Dec 2022 19:55:59 GMT

Hello World!
Firstly Happy Holidays to all the people around the world.

I want to create a new column Initial Mode. I have a dataset drom 2016-2022.
Here I have created a Final Payment Mode column. It means the last mode of that particular person was Visa.
If you look at the date, that person started from Decemeber 2021 and Ended in March 2022. In the very initial phase he had Mastercard Mode.

Now, i am having a biggest challenge here. I want to create a new column which will give me his 1st payment mode which is mastercard( dec 2021) IN THIS CASE.
(Note: You can see Final Payment mode Visa visa, twice in both rows. I will do distinct count at last)

I want a result like this. Column m (Initial Mode : Mastercard )
Please help.

Thank you

Re: DAX Help- Logical

Mahesh0016 — Wed, 21 Dec 2022 04:36:51 GMT

Create Calculated Column :

Initial Mode = CALCULATE(MAX('Master&Visa'[Prior Mode]),FILTER('Master&Visa','Master&Visa'[Prior Year]<MAX('Master&Visa'[Prior Year])))

Anonymous Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

topic DAX Help- Logical in DAX Commands and Tips

DAX Help- Logical

Re: DAX Help- Logical