cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TalhaTJ
Frequent Visitor

Counts of Number of Days Different

Hi, 

 

I had created a new Measure to calcuate days differnet in two column by using below command successfully.

 

Measure = DATEDIFF(SELECTEDVALUE('Version Table'[Actual Completion date]),SELECTEDVALUE('Version Table'[Final Completion Date]),DAY)

Its listing the values as below:

dd.PNG

 

I need to count the Number of days differnent like 

1day  2days   3days ... 

5        6           4

can any one help me to do this.

Thanks

 

1 ACCEPTED SOLUTION
asc
Frequent Visitor

Capture.PNG

DayDiff is my calculated column, here I have taken it 2 times

for 1st DayDiff :dont summarize

Capture1.PNG

for second column :take count

Capture2.PNG

I hope you got the solution.

View solution in original post

2 REPLIES 2
asc
Frequent Visitor

Hello,

 

Instead of creating mesure, create calculated column with same dax code. 

in visualization, take table visulazation and add this column 2 times. for one dont summarize it and for other take count.

 

asc
Frequent Visitor

Capture.PNG

DayDiff is my calculated column, here I have taken it 2 times

for 1st DayDiff :dont summarize

Capture1.PNG

for second column :take count

Capture2.PNG

I hope you got the solution.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.