cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
amitchandak
Super User
Super User

LTD Vs Period Retention considers that customer has never come before a given period. The definition of the new, retained, and lost customers are based on LTD(life till Date) and Period Data.

Read more...

amitchandak
Super User
Super User

There are 2 ways to install Power BI Desktop for the end users. Organizations has additional options. 

Read more...

amitchandak
Super User
Super User

YoY Retention is only focused on Year vs Year. The definition of the new, retained, and lost customers are only based on 2 Years of data i.e. This Year and Last Year.

Read more...

amitchandak
Super User
Super User

Pie Visual does not offer an option for conditional formatting, can we do conditional formatting on pie Visual

Read more...

amitchandak
Super User
Super User

Power BI Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD)

Read more...

amitchandak
Super User
Super User

When Data has been provided between the start date and end date. Output needs to be viewed by month or period. 

Read more...

amitchandak
Super User
Super User

Whenever we have targets, typically, they're at the month or Year level. All are other data like sales purchase is typically at the level. Now we want to analyze both these data together there is a challenge one data is at year level another data is at the day level. To deal with such scenarios we have options of creating a day level table or creating a measure that can give us the Day level target.

In this blog we are going to take the approach of creating a Measure, that will provide us data at the day level.

Read more...

amitchandak
Super User
Super User

If you are Power BI enthusiastic, what all links you should have handy with you. I compiled a list for you.

Read more...

amitchandak
Super User
Super User

Whenever we have targets, typically, they're at the month or at the year level. All are other data like sales purchase is typically at the level. Now we want to analyze both these data together there is a challenge one data is at the year level another data is at the day level. To deal with such scenarios we have options of creating a day level table or creating a measure that can give us the Day level target.

In this blog we are going to take the approach of creating a Table, that will provide us data at the day level.

Read more...

amitchandak
Super User
Super User

Customer retention refers to the ability of a company or product to retain its customers over some specified period. Here, we will measure how long we were able to retain a customer since its first date of purchase. What Kind of customer we would like to retain.

Read more...

monaraya
Microsoft
Microsoft

We couldn't connect to model in Power Bl Service. The dataset may have been deleted, renamed or it is possible that don't have permission to it.No OLE DB Error Information found.

Read more...

amitchandak
Super User
Super User

Customer retention refers to the ability of a company or product to retain its customers over some specified period. Here, we will measure how long we were able to retain a customer since its first date of purchase.

Read more...

amitchandak
Super User
Super User

Customer retention refers to the ability of a company or product to retain its customers over some specified period. There are many ways to measure the data. In the last blog (blog link), we have checked MoM (Month on Month) Retention. Here, we will go through Period over Period or POP.

Read more...

ibarrau
Super User
Super User

Recently, I have noticed that there was a lot of content talking about gzip decompress with Power Query, but I haven't seen someone talking about decompressing .zip files. The truth is that gzip is a most common file extension for data with the Azure suite. We can handle gzip with Azure Data Lake and Azure Data Factory. Anyway, in this article we will check how to decompress a ZIP file to explore your files inside, like a Windows folder in Power Query, in a very similar way as the gzip is done. If you haven't seen how gzip works, you can check this post about it.

Read more...

amitchandak
Super User
Super User

When it comes to dealing with DirectQuery, most of us think that columns are not allowed. But this is not true. We can directly create columns to let us explore more. Can we use date table create in Power BI for getting time intelligence?

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.