Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hiiii
Currently I have this dax function
@camelia_ ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak ,I am sorry that i really can't share any of the data, but the problem is that for example
from Sample Transactions excel sheet, i have a list of traded date and price, somewhat like this
Traded date | Traded price | Buy/Sell | Buy/Sell reference |
1/1/22 | 22.56 | buy | 1 |
2/1/22 | 22.5 | buy | 1 |
3/1/22 | 22.0 | sell | -1 |
3/1/22 | 22.31 | sell | -1 |
4/1/22 | 23.0 | buy | 1 |
and the market price is from Price excel sheet, from this sheet is just a list of price based on everyday date, no duplicate date
so when i put it in power bi, i use the above measure to calculate the relative price, but for same date like the above table, (3/1/22), it come out blank in matrix table visualisation.
for creating the matrix table visualisation, i create relationship as below,
isin with isin (reference > price & sample transactions) , date with date (timeline > price & sample transactions)
do you happen to know how to fix this ?
and i have another problem, for relative price & gain/loss, i create function in power bi (like above), but these measure can't be summarized( don't have the summarize category in measure tool>properties),so i can't put these in the card visualisation.
How to fix this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |