User Profile
msarmento
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Re: stuck in an issue
If I got your problem right, you could just create a calculated column to create a new index for DC by Sales ID and use it on a Matrix visual. Here is the DAX that I created for this column: DC Ordered = VAR CurrentSalesID = [SalesID] VAR CurrentDate = [Dateandtime] RETURN "DC - " & CALCULATE( DISTINCTCOUNT([DCNo]), FILTER( ALL('Table'), 'Table'[SalesID]=CurrentSalesID && 'Table'[Dateandtime] <= CurrentDate ) ) And here is a matrix using this new calculated column:Re: Dataflow refresh error Date/Datetime
Wrapping all columns with a DateTime.Date funcion did the trick for me. each DateTime.Date([DataEmissao]) >= DateTime.Date(#date(2020, 12, 1)) or [DataEmissao] = null and DateTime.Date([createdon]) >= DateTime.Date(#date(2020, 12, 1)) EDIT: Forget to mention, for me it started, out of the blue, on the 6/12. My company is in Brazil, but our Power BI tenant is in South Central US.
