topic Excel formula Equivalent to DAX, Or Something similar in DAX Commands and Tips

Excel formula Equivalent to DAX, Or Something similar

Gaab — Fri, 27 Oct 2023 13:27:35 GMT

Hello guys, so i have an issue with some formulas from excel. I want to integrate some formulas from excel to Power Bi because my raw data will be huge and power bi would work faster with it. The issue is that i can not find the equivalence of all of the formulas in power BI. I will put some examples below and provide some information.

In the column W I have these formula that separates me the Log out in periods that are separated by Log in. The biggest issue is that these formula is based on the same colomn where it is used, and in powerbi i do not know if it is possible.

In column T are 3 types of activity : Log in , Log out and Sleep. And i just need a formula that separates me in "Periods" Log out rows that has between them even a Log In row. And if there are rows with Sleep, the period should remain the same as Log out as it can be seen in above formula.
Is there a chance that i can do that? Or something similar?

Re: Excel formula Equivalent to DAX, Or Something similar

lbendlin — Sat, 28 Oct 2023 20:43:47 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Excel formula Equivalent to DAX, Or Something similar

Gaab — Wed, 01 Nov 2023 12:05:31 GMT

Here is the link to WeTransfer for a dummy file https://we.tl/t-M6FUa2JKbt .
The only thing that i need to in PowerBi is to make a grouping that separates Log Out rows that has between them, Log In Rows. But I am unable to do that.

Re: Excel formula Equivalent to DAX, Or Something similar

lbendlin — Wed, 01 Nov 2023 12:49:15 GMT

So you want the [Distinct Day Type] value to start at 1 and then increase by 1 whenever the [Activity Type] is "Log in" ?

How is the [Count] value calulated?