Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculation made based on user screen selection (date)

Hi, I’m new to power bi, I been trying to solve this but don’t have enough knowledge of DAX to solve this or I might be complicating things ☹   I need to create a dynamic report, where the users ca...
colacan's avatar
colacan
Resolver II
3 years ago

Anonymous  Hi, you can try below;

 

CALCULATE(SUM(Financement[Payment_1__c]),
                    KEEPFILTERS(DimDateAutorisee[date] < DATE(2021,1,1))
)

Hope this helps. Thanks