Forum Discussion
Repeat Selected Value Across Rows In Measure
- 3 years ago
Many thanks you for the solution PiEye !
Your proposed formulas were not exactly what i needed, but i player around a bit on them and i found the right ones.
For Full Year this is what worked for me (i had to add " 'Dim Calendar' " to the "ALL()" expression):
Value FY repeat 6 = CALCULATE( [Value All Data k$ MTD Demo Daily], all('Dim Calendar'), 'Dim Calendar'[Fiscal Year] = SELECTEDVALUE('Dim Calendar'[Fiscal Year]) )For QTR same (i had to add " 'Dim Calendar'[Fiscal Period] " to the "ALL()" expression):
Value QTR repeat 7 = CALCULATE( [Value All Data k$ MTD Demo Daily], all('Dim Calendar'[Fiscal Period]), 'Dim Calendar'[Fiscal Quarter] = SELECTEDVALUE('Dim Calendar'[Fiscal Quarter]) )I have now the same values on the absolute numbers which i could then divide to get the right Daily numbers.
Hi daniel_baciu , sure!
Can you open this link? https://drive.google.com/file/d/1eccjYD3Ushtie-pAEULjQTI743iQuPCS/view?usp=share_link
Pi
Hi PiEye - no, i cannot, but i have requested it using the Request access button.
- PiEye3 years ago
Resolver II
Have got the request & granted access. Let me know if you run into any more issues