Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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:
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
Solved! Go to Solution.
DayDiff is my calculated column, here I have taken it 2 times
for 1st DayDiff :dont summarize
for second column :take count
I hope you got the solution.
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.
DayDiff is my calculated column, here I have taken it 2 times
for 1st DayDiff :dont summarize
for second column :take count
I hope you got the solution.
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
71 | |
50 | |
46 |
User | Count |
---|---|
46 | |
38 | |
29 | |
28 | |
28 |