datefilterpowerbidaxmeasure
Power BI how to display latest value of a column based on date slicer and filter?
I have a Power BI table looks like this:
| Cat | Price | Date |
|---|---|---|
| apple | 2.0 | 03/21/2021 |
| peach | 3.0 | 03/22/2021 |
| apple | 1.8 | 03/18/2021 |
| apple | 2.0 | 03/19/2021 |
| peach | 3.1 | 03/20/2021 |
| apple | 1.7 | 03/17/2021 |
I want to use a date slicer and Cat filter to choose the latest price for Apple and display in a tile:
Date Slicer: 03/12/2021 - 03/21/2021
Filter: check 'apple'
Tile display: 2.0
I tried
price_LastValue := CALCULATE(SUM(fruit[Price]), LASTDATE(fruit[Date]))
but the result is BLANK. Any thoughts?
Solution
price_LastValue =
VAR _tbl = ALLSELECTED(Table1)
VAR _max_date = MAXX(_tbl, [Date])
RETURN MINX(FILTER(_tbl, [Date] = _max_date), [Price])
- How to list all the removable devices with DBus and UDisks2?
- gobject/gnome/glib bindings for D using GIR?
- How do nested functions get compiled?
- The "this" pointer and message receiving in D
- 64-bit executables with DMD
- GtkD with D lang on Fedora
- Why Android used Java concept instead of D language or C or C++? But Chromium web browser is in C++, its very complicated match
- How to use MongoItemWriter to write a List<T>
- Why a function with protected modifier can be overridden and accessible every where?
- Convert Unicode const(uint)* to a dlang character type
- Compiling D with Code::Blocks
- DMD vs. GDC vs. LDC
- Rendering a font in raylib using freetype
- Digital Mars D compiler; acquiring ASM output
- D Programming: openssl rsa forward reference compiler error
- D compiler DMD doesn't link object files
- OPTLINK: Warning 23: No Stack
- Is there a limit in the amount of temporary generated symbols during a project build using dmd 2.063?
- Is this the right way to combine Garbage collected with none Garbage collected code in D
- D compiler (Digital Mars D Compiler) throwing error
- Which D Compiler to Use?
- Splitting a string treating multiple whitespace as one separator
- Proper way of passing array parameters to D functions
- Detailed Valgrind internals documentation
- Is it possible, in D, to tell the garbage collector to not scan a particular pointer (or anything below it)?
- Iterate over key/value pairs in associative array in D.
- Dlang associative array of an array of strings keyed by a string has unexpected behavior
- How to repeat a statement N times (simple loop)
- Is worth the effort to learn D?
- ld: undefined reference to object I can see in objdump