Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

curmonthoffset behavior on q level

HI, I am using the calendar table createdby Avi Singh. I am confused about the behavior of the curmonthoffset column.  This is the code for the table:    let /* ****This Calendar was crea...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I found a solution myself:

    Cumulative Won MRR = 

SWITCH(
    TRUE(),
and(SELECTEDVALUE(Dates[CuryearOffset])=0,and(SELECTEDVALUE(Dates[CurmonthOffset])=0,SELECTEDVALUE(Dates[CurQuarterOffset])=0)), 1),
0)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Qtr year is also from dates table  ?

 

Try like

maxx(SELECTEDVALUE ( Dates), Dates[CurMonthOffset] ) = 0

Anonymous's avatar
Anonymous
Not applicable
4 years ago

 Qtr year is also from dates table  ? - yes

maxx(SELECTEDVALUE ( Dates), Dates[CurMonthOffset] ) = 0  - THIS Measure does not work, it should be maxx(Dates,SELECTEDVALUE (Dates[CurMonthOffset] )) = 0 i assume, but why would that solve the issue? (it does not change the outcome in the table)



  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , I think my mistake, it should be

     

    maxx(allselected( Dates), Dates[CurMonthOffset] ) = 0

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      why would this possibly work though? this formula just shows me the max curmonthoffset i have in the table, it does not do anything related to whether the one on the current row is 0 or not.
      There is no sample data, just the calendar table that I gave and the measure.