Measures and KPIs in Excel. Power Pivot for beginners

This video explains how to use Power Pivot and add measures with KPIs in Microsoft Excel. The tutorial explains how to add data to the power pivot window and then how to create a pivot table from that data. The tutor demonstrates how to add measures using the LastDate and FirstDate functions along with DateDiff. After the measures are added the tutor explains how to add KPIs to display visual indicators.

Playlists for this channel:

#itseasytraining

Courses are available through Microsoft Teams, Online and Face to face in the UK

Training Guide Books

Excel for New Managers

Very cheap E_books are here:

[hiteshjoshi]

sir thanks for the explanation could you please let us know how to create single card with measures

[idolsensei]

Hi,

What if I have a RAG in excel already which I need to import in Power BI. How can it recognize that RAG buttons are already placed in excel? I tried to import it but when I placed the column with RAG, the number corresponds to the RAG color only appeared. I tried changing the data types but still wont show the RAG buttons. Might have missing something.

Appreciate your advise.