Forum Discussion

BIuser0424's avatar
BIuser0424
Regular Visitor
3 years ago

Two different Month Columns visualization help

I am analyzing sales proposals vs a target. I have two date columns. One that shows the anticipated contract month, the other is the expected budget month. I am trying to chart the difference between...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi BIuser0424 

You can create a date table

e.g 

Date =

ADDCOLUMNS (

CALENDAR (DATE (2020, 1, 1), DATE (2022, 12, 31)),

"Year", YEAR([Date]),

"MonthNumber", MONTH([Date]),

"Quarter", QUARTER([Date]),

"DayOfWeek", WEEKDAY([Date])

)

Then create relationship between the date table and data table 

e.g one-many:[Date]->[ anticipated contract month]   one-many:[Date]->[expected budget month] 

If one of these two relationships is inactive, the USERELATIONSHIP() function can be used

e.g 

CALCULATE(....,USERELATIONSHIP([expected budget month],[Date]))

You can refer to the folloiwng link about the relationship and USERELATIONSHIP() function 

USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Active vs inactive relationship guidance - Power BI | Microsoft Learn

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.