Date Difference in Direct Query with possibility to show on a grouped bar chart

[Matthijs12345]

Hello,

I want to calculate the difference between two dates. It is for me possible to do it in a measure, but it is not possible to get the networkdays in a group bar chart. See the result:

This is in a measure, but i cant create a calculated column or Power Query. How do i get the data in a grouped bar chart?

[MFelix]

Hi @Matthijs12345 ,

Using this measure you can create another one based on the calculation of this one.

I don't have an idea how you have the table setup but if you do something similar to this should return expected result:

Total network days = SUMX(VALUES(Table[Column to groupby]), [Aantal werkdagen])

If this does not return the expected result try to do a summarize of the table with the values you need for the grouping, but for that without any data is difficult to pin point the exact code of the measure.