Forum Discussion
Incorrect DIVIDE result when dividing two meausres
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.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523