Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Two dates from the same database

Hello, good afternoon!! I have the following drawback: In a DB I have guide creation dates and a guide entry date, in a table I need to reflect how many guides created and how many guides ent...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jmatamal ,

    If I understand correctly,  you would like to get the count of guides created and guides entered. But you can't get the correct count of guide entered. Can I  know how did you set your table visual in Power BI? Please try to follow the steps below to do it and check if you can get the expected result...

    1. Delete the relationship between the calendar table and fact table

    2.  Create a table visual: put the field [Fecha] of calendar table and the following two measures onto the table visual

    Count of guides creation =
VAR _seldate =
    SELECTEDVALUE ( 'Calendario'[Fecha] )
RETURN
    CALCULATE (
        COUNT ( 'ReporteIngresoGuiasxx'[Fecha_Creacion] ),
        FILTER (
            'ReporteIngresoGuiasxx',
            'ReporteIngresoGuiasxx'[Fecha_Creacion] = _seldate
        )
    )
    Count of guides entered =
VAR _seldate =
    SELECTEDVALUE ( 'Calendario'[Fecha] )
RETURN
    CALCULATE (
        COUNT ( 'ReporteIngresoGuiasxx'[Fecha_Ingreso] ),
        FILTER (
            'ReporteIngresoGuiasxx',
            'ReporteIngresoGuiasxx'[Fecha_Ingreso] = _seldate
        )
    )

    Best Regards

Arul's avatar
Arul
Super User
3 years ago

Syndicate_Admin ,

try the below, May be this would help.
Step 1: You need to create the inactive relationship between calendar table Date column and fact table ingestion date column. Please refe the attached image.

Step 2: You have to write a measure to get the correct ingestion date count by making the inactive relationship into active through USERELATIONSHIP dax function.

Ingestiondate count =
CALCULATE (
    COUNT ( Reportingestion_fact_table[Ingestion date] ),
    USERELATIONSHIP ( 'Calendar'[Date], Reportingestion_fact_table[Ingestion date] )
)

Step 3: Use the newly created measure in your report.

Thanks,

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hello, good morning!!!

I only have a small inconvenience when entering the measurement, it does not show the date of the last registration

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi jmatamal ,

    What's the meaning of "the date of the last registration"?  What's your final expected result? Could you please provide some raw data in your fact tables and special examples to explain it in order to get better unerstanding on your requirment and give you a suitable solution? Thank you. 

    Best Regards