Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am creating a matrix table with name, item ID, Item description on rows.
Month-Year = FORMAT('Data'[Planned Date],"mmm yyyy") on columns and supply qty in values
customer name | vendor item id | item id | desc | Jan-24 | Feb-24 | Mar-24 |
50 | 10 | 15 |
Solved! Go to Solution.
@wisekyn77
Try this meaure:
YourMeasure =
IF (
MONTH ( SELECTEDVALUE ( 'Data'[Planned Date] ) ) = 1,
CALCULATE ( [Measure], 'Data'[Planned Date] <= MAX ( 'Data'[Planned Date] ) ),
[Measure]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@wisekyn77
Try this meaure:
YourMeasure =
IF (
MONTH ( SELECTEDVALUE ( 'Data'[Planned Date] ) ) = 1,
CALCULATE ( [Measure], 'Data'[Planned Date] <= MAX ( 'Data'[Planned Date] ) ),
[Measure]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group