Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, community!
I'm new in power bi and I need your help 🙂
I have a table "Cash_flow", there are the columns with:
One flat can have several contracts. I want to get only contracts with the latest date by one flat.
Can anybody help me?
Thank you in advance!
Solved! Go to Solution.
Hi @bbodnar,
You can create a measure and add it in the Visual level filter if you don't want to add it in the visual.
Measure = VAR maxDate = CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[FlatID] ) ) RETURN IF ( MIN ( Table1[Date] ) = maxDate, 1, BLANK () )
Best Regards,
Dale
Hi @bbodnar,
Please mark the proper answers as solutions.
Best Regards,
Dale
Hi @bbodnar,
You can create a measure and add it in the Visual level filter if you don't want to add it in the visual.
Measure = VAR maxDate = CALCULATE ( MAX ( Table1[Date] ), ALLEXCEPT ( Table1, Table1[FlatID] ) ) RETURN IF ( MIN ( Table1[Date] ) = maxDate, 1, BLANK () )
Best Regards,
Dale
Hi
Is there any way to create this dynamically with respect Max Date Selected in Date Slicer.
Similar question is answered here. This may help you.
http://community.powerbi.com/t5/Desktop/Max-Row-Based-on-Insert-Date/td-p/446426
Thanks
Raj
User | Count |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |