how to write dax calculation Power bi

0 votes
ID, Name,Stausdate

1,A,6/8/2020

2,B,6/7/2020

3,C,6/6/2020

4,D,6/5/2020

--------------------

----------------

How to Create a DAX CAlculation Based on Stausdate ( Last 5 Days) data.

I mean Last 5 days of Statusdate data display in Text Table.

As per your understanding last statusdate is: 6/8/2020 so i need  dax cal for 6/8/2020 earlier data for Last 5 days.
Jun 11, 2020 in Power BI by vnk
• 390 points
1,010 views

Hi, @Vnk,

You can calculate DAX in the same way shown here https://www.edureka.co/community/71307/last-10-days-data-based-on-date-time

Hope this helps

1 answer to this question.

0 votes

Hi, @vnk

You can make use of this given below:

calculate( count(Date), Filter(all( table), Date<= Max(Date) and Date >= max(Date)-5))

Related FAQ

How to rename a column using DAX in Power BI

answered Aug 5, 2020 by code_Damon

Related Questions In Power BI

0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,890 points
1,812 views
+1 vote
1 answer

How to resolve Power BI DAX Join error?

Sample Table Used Here: Table1: Partner_ID, User_Id Table2: User_Id, ...READ MORE

answered May 15, 2019 in Power BI by Avantika
• 1,520 points

edited May 15, 2019 by Omkar 4,031 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 22, 2019 in Power BI by anonymous
• 33,030 points

edited Dec 31, 2021 by Soumya 36,674 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

answered Oct 27, 2020 in Power BI by Gitika
• 65,890 points
984 views
0 votes
1 answer

How to use Dynamic DAX Number Format in power BI?

You can give them the same display ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,890 points
2,369 views
0 votes
1 answer

How to restart running total column with Power BI Desktop DAX?

This is not only a running total ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,890 points
1,861 views
+2 votes
0 answers

Assume referential integrity

1) What is Assume referential integrity? what ...READ MORE

Aug 19, 2019 in Power BI by vnk
1,666 views
+2 votes
1 answer

If Condition

DAX - I assume [Claim_line].[Allowed_Amount_B6] is one ...READ MORE

answered Aug 20, 2019 in Power BI by anonymous
• 33,030 points
1,492 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23, 2019 in Power BI by anonymous
• 33,030 points
6,565 views
+1 vote
1 answer

Power Bi to Machine Learning Model

Hello @vnk! Power BI only supports Azure Machine ...READ MORE

answered Dec 3, 2019 in Power BI by Priyanka
1,030 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP