Forum Discussion
Helper IIF statment doesn't work!
Helper IHi Anonymous,
Thank you very much. It it very helpfull!
I was wondering if you don't mind checking out my other post. Maybe you could think of a better idea on how to do this. I was thinking maybe, if I create new tables from each column and then build relationships, that would be a good approach, I'm not sure!?
I really appreciate your help!
Ben.
Beyondforce Just looking at it quickly, it seems that you should just be able to relate the transaction date to the new date table I outline above. I assume the table you are creating is a visual... It should be really straightforward from there.
The date table will have year and month name
you can create a measure like this: countdate = COUNTA('Date'[Date]) for the days of month
Then it sounds like some straightforward counts on dates or other fields to round out the solution.
If this is over-simplifying, let me know - but the date table will do most of the legwork for the year/month/count of days for sure.
- Beyondforce
Anonymous, I have found a better way... I have asked the guy who created those files, to add the extra columns that I need ;-)
Thanks for the help.