Uploaded June 2025 | Updated September 2026, 2 days ago
Power BI DAX Formula tutorial for counting those dates in which activity has been performed in last n days. This is useful for scenarios project activity, sales activity, supply chain activitiy or IT systems activity to correctly identify the output based on last N days slicer.
Connect with me:
LinkedIn - linkedin.com/in/abhishek-agarwal-9549876
Twitter - https://x.com/agarrwal7
Need Advance Dashboard Training? Contact - abhishek.agarrwal@gmail.com
Advance Dashboard Training Details - docs.google.com/presentation/d/1ArqwjW9F-1Q-Zz2wV0SxwUrp8G_Cn8ScP4pi1v9wkhw/edit?usp=sharing
Join my private group for communcations - tinyurl.com/yd65vnf3
Dataset -
docs.google.com/spreadsheets/d/1a5c2Ubetp3eUW3ctySSyyOVVdk5UfiYYuTbIMKsIB0k/edit?usp=sharing
Tutorial Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
Power BI DAX Formula tutorial for counting those dates in which activity has been performed in last n days. This is useful for scenarios project activity, sales activity, supply chain activitiy or IT systems activity to correctly identify the output based on last N days slicer.
Connect with me:
LinkedIn - linkedin.com/in/abhishek-agarwal-9549876
Twitter - https://x.com/agarrwal7
Need Advance Dashboard Training? Contact - abhishek.agarrwal@gmail.com
Advance Dashboard Training Details - docs.google.com/presentation/d/1ArqwjW9F-1Q-Zz2wV0SxwUrp8G_Cn8ScP4pi1v9wkhw/edit?usp=sharing
Join my private group for communcations - tinyurl.com/yd65vnf3
Dataset -
docs.google.com/spreadsheets/d/1a5c2Ubetp3eUW3ctySSyyOVVdk5UfiYYuTbIMKsIB0k/edit?usp=sharing
Tutorial Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
![Qlik Sense Basic Tutorial for Beginners [2024] - Complete Tutorial - Getting Started - Part 1](https://i.ytimg.com/vi/q-3wKfdmiJE/mqdefault.jpg "Qlik Sense Basic Tutorial for Beginners [2024] - Complete Tutorial - Getting Started - Part 1
Qlik Sense tutorial for beginners where Ill teach you qlik sense from scratc. Well start with how to download and install qlik sense and then well see how we can unlock the qlik sense, then well look at the data that well use and then well import the excel data in qlik sense and then well apply the filter in on the data and load data. Once data is loaded in qlik sense then well look at the data manager to understand how we can review the data, remove or change the filters and also apply setting like replacing value, setting null values, splitting values and the statistic of the column like how many unique values it has.
Once well complete the review of data manager in qlik sense, well then create and format the KPIs for Qlik Sense business performance dashboard and then well create and format bar chart, line chart, tree map chart and scatter chart.
A lot of tips and tricks related to distinct values and enabling data labels, formatting data lables and removing the header of kpis will be discussed and implemented.
Here Ive taken the project based approach where Ill show you the final qlik sense dashboard that youll create and then step by step well create this qlik sense dashboard end to end.
Github link to download qliksense and unlock file - https://github.com/qlik-download/qlik-sense-desktop/releases/
Dataset Link https://tinyurl.com/yd65vnf3
Previous Qlik Sense Tutorial Video - https://youtu.be/zs24DVVIALU
Questions? - abhishek.agarrwal@gmail.com
Important Timestamp in this video
1:02 Topics discussed in this tutorial
4:03 How to download and install Qlik Sense Desktop
9:06 Reviewing the Qlik Sense dashboard that we’ll create today
11:10 Data used in this tutorial and reviewing it
14:32 Creating New App
18:00 Importing Data and Applying Filters
22:50 Reviewing the Data Manager
30:15 Creating and Formatting KPIs
43:33 Creating and Formatting Bar Chart
46:56 Creating and Formatting Line Chart
51:45 Creating and Formatting Treemap Chart
53:54 Creating and Formatting Scatter Scatter Chart
56:27 Creating Filters and interacting with filters
1:02:21 Next Steps – Next Sessions & Advance Dashboards Training")
![How to show [format] the vertical gridlines in power bi Table visual](https://i.ytimg.com/vi/r9smTbr4fZg/mqdefault.jpg "How to show [format] the vertical gridlines in power bi Table visual
Power BI Tutorial for beginners on how to format vertical grid lines in Table Visual by changing Color or size of the horizontal line or disabling them completely.
Need Basic to Advance Power BI Training? Contact - Abhishek.agarrwal@gmail.com
Dataset Link - https://tinyurl.com/yd65vnf3
Power BI Videos in Google Sheet - https://docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=share_link
Complete Power BI Tutorials Playlist - https://www.youtube.com/playlist?list=PL6_D9USWkG1Bn9Zv53ryWtPczn_05t3rG
Power BI Projects (50+) - https://www.youtube.com/playlist?list=PL6_D9USWkG1CahdDs0sU4hmrRfEqLXP1W
#powerbi #datavisualtion #table #gridlines #formatting #education")
