how to write dax calculation Power bi

Question

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.

Comments

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

Answer 1

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