Forum Discussion
Solved
Converting Logic From Excel to Power BI
I need some help transferring some Excel logic into Power BI. Basically, as you can see in the picture below, I want two seperate classifications in the form of calculated columns. The first, "Classi...
Please refer to this post for the answer:
Should be doable. Think the key bit would be to convert the month into something like 202003 for March 20, then try grouping by user in Power Query by the maximum and minimum of that column - the minimum would be your classification, the maximum would be the last time they had revenue, then you can add 1000 to the maximum to work out an inactive date?
Please refer to this post for the answer: