Forum Discussion
Solved
Incorrect DIVIDE result when dividing two meausres
Hi community! I am facing an issue with my DAX DIVIDE measure and would appreciate your insights on this . Data Model Overview: Date table: Marked as a date table with unique date fields. ...
After reviewing the data model, the problem was traced back to mismatched date formats from two data sources. The fact_items[date] column had a "ddmmyyyy" format, whereas the dim_google[date] column used the "yyyymmdd" format. Attempting to join data based on these mismatched date formats resulted in errors.
After reviewing the data model, the problem was traced back to mismatched date formats from two data sources. The fact_items[date] column had a "ddmmyyyy" format, whereas the dim_google[date] column used the "yyyymmdd" format. Attempting to join data based on these mismatched date formats resulted in errors.