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.
Hi,
I am trying to make a trend line chart, based on Start & Expired date. Below are the expected trend line and the data:
In my scenario, need to read my Start date Amount as ZERO always for respective ProjID and Expire_Date as
the Amount value. Also, in case there is another entry for the same ProjID with modified Start\Expiry date, then it should
read that value either in the same Line or as another line trend.
Could someone please help in it.
Thanks
Shishir G.
Solved! Go to Solution.
Hi Shishir,
Please download the demo in the attachment.
1. Create a date table. Don't establish any relationship.
2. Add an index since there could be more than one project ID.
3. Create a measure.
Measure = IF ( MIN ( 'Calendar'[Date] ) = MIN ( 'Table1'[Start_Date] ), 0, IF ( MIN ( 'Calendar'[Date] ) = MIN ( Table1[Expire_Date] ), SUM ( Table1[Amount] ), BLANK () ) )
Best Regards,
Dale
Hi Shishir,
Please download the demo in the attachment.
1. Create a date table. Don't establish any relationship.
2. Add an index since there could be more than one project ID.
3. Create a measure.
Measure = IF ( MIN ( 'Calendar'[Date] ) = MIN ( 'Table1'[Start_Date] ), 0, IF ( MIN ( 'Calendar'[Date] ) = MIN ( Table1[Expire_Date] ), SUM ( Table1[Amount] ), BLANK () ) )
Best Regards,
Dale
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |