Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

How to compute Stock Aging Amount by year ?

Hi All   I have below syntax working fine :- _SLOW_1_YEAR = IF ( TODAY () - SELECTEDVALUE ( INVC[Last Sales] ) >1 * 365 && SELECTEDVALUE ( INVC[Last Sales] ) <> BLANK (), 1, 0 )   _SLO...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

admin11 You can use an Append query in Power Query Editor or you could use UNION in DAX.

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

Greg_Deckler 

Thank you very much for your fast reply. 

Actually what i need to combine the below 2 syntax into 1 :-

 
_SLOW_1_YEAR =
IF (
TODAY () - SELECTEDVALUE ( INVC[Last Sales] ) >1 * 365
&& SELECTEDVALUE ( INVC[Last Sales] ) <> BLANK (),
1,
0
)
 
_SLOW_2_YEAR =
IF (
TODAY () - SELECTEDVALUE ( INVC[Last Sales] ) >2 * 365
&& SELECTEDVALUE ( INVC[Last Sales] ) <> BLANK (),
1,
0
)
 
So i can know 1 year and 2 year slow moving amount.
Paul
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    admin11 Just use a SWITCH(TRUE(), ) statement and put your IF true/false statements in as conditions, like:

    _SLOW_YEAR =
  SWITCH(TRUE(),
    TODAY () - SELECTEDVALUE ( INVC[Last Sales] ) >1 * 365
&& SELECTEDVALUE ( INVC[Last Sales] ) <> BLANK (),1,
    TODAY () - SELECTEDVALUE ( INVC[Last Sales] ) >2 * 365
&& SELECTEDVALUE ( INVC[Last Sales] ) <> BLANK (),1,
    0
  )