Forum Discussion

Mostafa-Hussien's avatar
Mostafa-Hussien
Icon for Helper I rankHelper I
2 years ago

Inventory Transaction Dates do not respond

Hi I have a very complicated inventory table in the database that I want to calculate the on-hand grouped by many dimensions. I am struggling to get it correctly. So I decided to breakdown the probl...
"DAX "
ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

Hi Mostafa-Hussien, create a new column:

 

AddDate = 
IF(
    ISBLANK(Test15[STOREADDITIONDATE]),
    Test15[STOREACTIONITEMSDATE],
    Test15[STOREADDITIONDATE]
)

 

or create a measure:

 

AddDate = 
CALCULATE(
    MAXX(
        ALLSELECTED(Test15),
        IF(
            ISBLANK(Test15[STOREADDITIONDATE]),
            Test15[STOREACTIONITEMSDATE],
            Test15[STOREADDITIONDATE]
        )
    )
)

 

 

 

Did I answer your question?  If so, please mark my post as the solution!✔️
Your Kudos are much appreciated!  Proud to be a Responsive Resident!