The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
42 | |
24 | |
23 | |
22 |