How to show current time day month and year using DAX in power bi

This recipe helps you show current time day month and year using DAX in power bi

Recipe Objective - How to show current time, day, month, and year using DAX in Power BI?

Step 1 - Open Power BI report

Step 2 - New Measure(Current time)

Go to Fields pane -> Right click on Dataset -> New measure

Step 3 - Dax query(Now function)

Write down the formula as Current_time = Now()

This will create a new measure that will display the current time.

Step 4 - New Measure(Current day)

Step 5 - Dax query(Day & Now function)

Write down the formula as Current_day = Day(Now())

This will create a new measure that will display the current day.

Step 6 - New Measure(Current month)

Step 7 - Dax query(Month & Now function)

Write down the formula as Current_month = Month(Now())

This will create a new measure that will display the current month.

Step 8 - New Measure(Current year)

Step 9 - Dax query(Year & Now function)

Write down the formula as Current_year = Year(Now())

This will create a new measure that will display the current year.

In this way, we can display the current time, Day, Month, and Year using DAX in Power BI.

What Users are saying..

profile image

Abhinav Agarwal

Graduate Student at Northwestern University
linkedin profile url

I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More

Relevant Projects

Build a Graph Based Recommendation System in Python-Part 2
In this Graph Based Recommender System Project, you will build a recommender system project for eCommerce platforms and learn to use FAISS for efficient similarity search.

Build a Speech-Text Transcriptor with Nvidia Quartznet Model
In this Deep Learning Project, you will leverage transfer learning from Nvidia QuartzNet pre-trained models to develop a speech-to-text transcriptor.

Stock Price Prediction Project using LSTM and RNN
Learn how to predict stock prices using RNN and LSTM models. Understand deep learning concepts and apply them to real-world financial data for accurate forecasting.

AWS MLOps Project for Gaussian Process Time Series Modeling
MLOps Project to Build and Deploy a Gaussian Process Time Series Model in Python on AWS

Mastering A/B Testing: A Practical Guide for Production
In this A/B Testing for Machine Learning Project, you will gain hands-on experience in conducting A/B tests, analyzing statistical significance, and understanding the challenges of building a solution for A/B testing in a production environment.

MLOps Project for a Mask R-CNN on GCP using uWSGI Flask
MLOps on GCP - Solved end-to-end MLOps Project to deploy a Mask RCNN Model for Image Segmentation as a Web Application using uWSGI Flask, Docker, and TensorFlow.

MLOps Project to Deploy Resume Parser Model on Paperspace
In this MLOps project, you will learn how to deploy a Resume Parser Streamlit Application on Paperspace Private Cloud.

Credit Card Default Prediction using Machine learning techniques
In this data science project, you will predict borrowers chance of defaulting on credit loans by building a credit score prediction model.

AWS MLOps Project to Deploy a Classification Model [Banking]
In this AWS MLOps project, you will learn how to deploy a classification model using Flask on AWS.

Isolation Forest Model and LOF for Anomaly Detection in Python
Credit Card Fraud Detection Project - Build an Isolation Forest Model and Local Outlier Factor (LOF) in Python to identify fraudulent credit card transactions.