Forum Discussion
Bokazoit
Continued Contributor
4 years agoNeed help with measure
This measure is created using a detached Date dimension - as can be seen from this data model: Doing that makes it possible to calculate the correct distinct count, using this DAX: ...
Bokazoit
Continued Contributor
4 years agoHere is a sample file:
https://drive.google.com/file/d/1yjp20i4tZP0GAnSbSe-06f4TtkQowIrh/view?usp=sharing
There is two sheets, and the results in each sheet is correct, but for the result in the sheet 'Forecast' to be correct, I need to create a new date dimension as described above. I would like to use just the Primary date dimension.
Hope this gives You what You need.
Thx in advance 🙂
Payeras_BI
Solution Sage
4 years ago