Forum Discussion

Dicken's avatar
Dicken
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Average granularity

Hi, i have a  question iif  i have a fact tabel, over a copupe of years, but not all years have all months  ,  so example may start Feb  to Oct.     if i  want an average  total / 12  if    so  I...
Need Help
Show and Tell
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi Dicken ,

     

    May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

     

    Thank you!!

Dicken's avatar
Dicken
Icon for Post Prodigy rankPost Prodigy
1 year ago

I think an approach, and I have not got this working , it to use parallelperiod,   so 

EVALUATE 
SELECTCOLUMNS( 
PARALLELPERIOD( 'Calendar'[Date],0,YEAR),
"N", FORMAT( 'Calendar'[Date],"MMM-YYYY") )

would give a single row table  to iterate over  and would conatain all dates, just an idea.