Forum Discussion
Monthvalue transform to week/day value
I have sales data in my data model that I want to compare to a planned value. The plan data is only available on a monthly level. In the chart I would like to visualize the ACTUAL data with the planned data by drilling down to month, week and day.
Therefore, I want to transform the monthly value (plan) via a measure to week and day.
I have joined the fact_sales table and the fact_plan table with the DimDate table.
The plan data looks like this:
Date - Value
01 Jan 22 - XX
01 Feb 22 - XX
01 Mar 22 - XX
3 Replies
DueckJ , refer if this can help
Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798
Thanks. That already looks quite good. One addition, I want to consider only working days from my DimDate (in the DimDate table I have a marker with all working days).
HI DueckJ,
You can add a calculated column to your calendar table to check with the weekday function to remark week number/workdays.
WEEKNUM function (DAX) - DAX | Microsoft Docs
WEEKDAY function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
