The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
Dax expression needed from the below table list :
Tablename /Dataset name: Projection
i need to derive Latest CurrentRate by considering last RunMonth for each MeasureID field [by using calculated Measure]
output from below is: 0.4733 from BCR Measure
TRENDMONTH | RunTrendMonth | TIMEFRAME | measureid | submeasure | Measure Type | CurrentRate |
1 | 2019011 | PROSPECTIVE | BCR | Hybrid | 0.3862 | |
2 | 2019022 | PROSPECTIVE | BCR | Hybrid | 0.392 | |
3 | 2019033 | PROSPECTIVE | BCR | Hybrid | 0.41 | |
4 | 2019044 | PROSPECTIVE | BCR | Hybrid | 0.4307 | |
5 | 2019055 | PROSPECTIVE | BCR | Hybrid | 0.4465 | |
6 | 2019066 | PROSPECTIVE | BCR | Hybrid | 0.4575 | |
7 | 2019077 | PROSPECTIVE | BCR | Hybrid | 0.4733 |
Have you tried LASTNONBLANK()
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |