Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!