Forum Discussion

Pra2010Gha's avatar
Pra2010Gha
Icon for Helper I rankHelper I
10 months ago
Solved

Dax command to get the values based on paramter date

Hi I want  a dax command to get the values highlighted based on transaction date parameter. Say a customer who did a transaction on 18th october and comes back to return those products  on 30 ...
  • v-hashadapu's avatar
    v-hashadapu
    10 months ago

    Hi Pra2010Gha , Thanks for reaching out to the Microsoft fabric community forum.

     

    I have created a new .PBIX file based on your requirements. Instead of using field parameters, I used a slicer for the date column, as field parameters are not the most suitable option here.
     

    On page 1 of the report, you can use the slicer—set it to 18th Oct to get the desired output, which is 3.5 + 6 = $9.5. On page 2, I added a table with a DAX measure to show the price of the fruits on the transaction date. You can use whichever option works best for you. 

     

     

    Please refer to the attached .pbix file for more details and let me know if you have any further questions.
    Thank you.

Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
10 months ago

HI Pra2010Gha ,

 

try below measure:

Return Amount = 
VAR TransactionDate = [transaction date]  -- Your parameter date (10/18/2025)
VAR CurrentProduct = SELECTEDVALUE('YourTable'[product])

VAR CorrectPrice = 
    CALCULATE(
        MAX('YourTable'[base price]),
        FILTER(
            ALL('YourTable'),
            'YourTable'[product] = CurrentProduct &&
            'YourTable'[date price change] <= TransactionDate
        )
    )

RETURN
CorrectPrice
Total Return Amount = 
VAR TransactionDate = [transaction date]  -- 10/18/2025

RETURN
SUMX(
    VALUES('YourTable'[product]),
    VAR CurrentProduct = 'YourTable'[product]
    VAR CorrectPrice = 
        CALCULATE(
            MAX('YourTable'[base price]),
            FILTER(
                ALL('YourTable'),
                'YourTable'[product] = CurrentProduct &&
                'YourTable'[date price change] <= TransactionDate
            )
        )
    RETURN CorrectPrice
)

Create one more  measure to get transaction date as input from slicer/parameter and use it in above measures

 

Thanks and Regards,

Praful